Data refresh from production to development
I need to refresh development database with a particular schema from production.
Below is the process I am planning to follow:
1) ensure that on development there is enough space to accomodate the schema
2) On production get data dump directory by running
SELECT directory_name, directory_path FROM dba_directories WHERE directory_name='DATA_PUMP_DIR';
if no directory specified, create it by running
CREATE or REPLACE directory DATA_PUMP_DIR as ‘/u01/export/ProdDBName’;
3) Retrieve the flashback_scn
4) Run expdp tool to generate the dump file
5) cd into data dump directory (/u01/export/ProdDBName) and use ftp to transfer the dump file to development database:
0