The export operation is performed with data that is consistent up to the specified SCN. If the NETWORK_LINK parameter is specified, then the SCN refers to the SCN of the source database.

Follow following steps to the export database using network-link.

Source database: demo

Target database: uat

Database platform :

Step 1 : Create a tnsnames.ora entry with source database.

Step 2 : Connect to target database

Step 3: Create a directory in target database server where you want to put your dump file and give read-write permission to the oracle user with which you want to take expdp backup.

Step 4 : Create a database link with tnsnames.ora entry we mentioned earlier.

Step 5 : Take backup using expdp with netwok_link parameter

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply