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
Hello, how would you import when there are links with same name in the DB?
ReplyDelete