expdp / impdp of schemas in PDB
— add tns entry for pdb in tnsnames.ora if it is not there
— export from source database
expdp user@sourcepdb dumpfile=myschema_june30.dmp logfile=myschema_june30.log directory=DATA_PUMP_DIR SCHEMAS=myschema
— import in target database
drop user myschema cascade;
–(no need to create schema user because import will create it)
impdp user@targetpdb dumpfile=myschema_june30.dmp logfile=imp_myschema_june30.log directory=DATA_PUMP_DIR SCHEMAS=myschema
No comments yet