STEP BY STEP DATABASE REFRESH.

In this post, I am going to describe to you, step by step process for database refresh using datapump (EXPDP/IMPDB). In this example, my source database name is MYDB where the target database is AVANI

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.

Please find the step by step process which you can follow in your environments.


1. Always remember to check the database name before export or import.


SQL> select name from v$database;

NAME ——— MYDB


2. Check the space utilize by schema before export.