![]() ![]() Check the username and tablespace before export so you can compare thing before import. SQL> select owner,sum(bytes)/1024/1024 “MB” from dba_segments group by owner ģ. Check the space utilize of by schema before export. Always remember to Check the database name before export or import.Ģ. Please find the step by step process which you can follow in your environments.ġ. I found many DBA forget to restore old password while import or not checking invalid object before giving ok to a requester who requested for database refresh from production to test or development databases. In this example, my source database name is MYDB where the target database is AVANI In this post, I am going to describe you, step by step process for database refresh using datapump (EXPDP/IMPDB). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |