Overblog
Suivre ce blog Administration + Créer mon blog

[datapump]

[Datapump] : good use of IMPDP

HIDDEN CONTENT 1) clean target schema if FULL import.(check recycle_bin=off) drop user XXXX cascade; 2) clean NOT RUNNING datapump jobs set verify off define job= SYS_EXPORT_SCHEMA_04 exec DBMS_DATAPUMP.STOP_JOB (DBMS_DATAPUMP.ATTACH('SYS_EXPORT_SCHEMA_04','SYS'),1,0);...

Lire la suite