Pre checklist for export and import schema
Hello all,
I'm planning to refresh dev database ( oracle 12C ) using expdp/impdp.
Prior to that, i need and input what's the complete checklist should i update in my workplan.
Here is the list;
1. expdp ABC schema
dumpfile=DATA_PUMP_DIR:ABC.dmp
logfile=DATA_PUMP_DIR:ABC.log
filesize=10G
schemas=ABC
2. run query to drop schema XYZ objects on target db
SELECT 'DROP '|| OBJECT_TYPE || ' ' ||OWNER||'.'||OBJECT_NAME||';'
FROM SYS.DBA_OBJECTS WHERE OWNER = 'ODSTRN' AND OBJECT_TYPE IN ('LOB','PACKAGE','SEQUENCE','VIEW','FUNCTION','PROCEDURE','SYNONYM','TRIGGER');
3. run impdp
directory=DATA_PUMP_DIR