Sunday, April 19, 2020

EXPDP / IMPDP Database Links (dblinks)

EXPDP / IMPDP Database Links (dblinks):



Use include parameter include=db_link Example: expdp \’/as sysdba\’ full=y directory=data_pump_dir include=db_link dumpfile=dblink_expdp.dmp logfile=dblink_expdp.log

For importing, we can import as below.

impdp \’/as sysdba\’ full=y directory=data_pump_dir dumpfile=dblink_expdp.dmp logfile=dblink_expdp_imp.log

or

impdp \’/as sysdba\’ include=db_link directory= data_pump_dir dumpfile=dblink_expdp.dmp logfile=dblink_expdp_imp.log

No comments:

Post a Comment

student guide Dataguard: GLOBAL_DBNAME = <dbuniquename>_DGMGRL.example.com  Example: listener.ora on Primary Hosts Static listener ent...