Friday, 6 January 2017

expdp dblinks and impdp dblinks


Exporting DBlinks:


We use include parameter include=db_link to export database links from database. below is the example.


expdp \'/as sysdba\' full=y directory=dblink_dir include=db_link dumpfile=orcl_DBlink.dmp logfile=orcl_DBlink.log

For importing, we can import as below.

impdp \'/as sysdba\' full=y directory= dblink_dir dumpfile=FSPRD_DBlink.dmp logfile=FSPRD_DBlink_imp.log

or

impdp \'/as sysdba\' include=db_link directory= dblink_dir dumpfile=FSPRD_DBlink.dmp logfile=FSPRD_DBlink_imp.log

1 comment:

  1. Hello, how would you import when there are links with same name in the DB?

    ReplyDelete