How to Use EXPDP with NETWORK LINK | Oracle EXPDP Remote Export Using DB Link from REMOTE database
In this video, you will learn how to use Oracle Data Pump EXPDP with NETWORK_LINK to export data from a remote database using a database link.
This is a practical Oracle DBA tutorial where we configure a database link, test connectivity, and perform schema export step by step.
🔹 Topics Covered:
✔ What is NETWORK_LINK in Oracle
✔ Creating DIRECTORY object
✔ Creating DATABASE LINK
✔ Testing database link connection
✔ EXPDP with NETWORK_LINK command
✔ Importing dump file using IMPDP
✔ Verifying schema in target database
🔹 Commands Used:
Create Directory:
CREATE OR REPLACE DIRECTORY db_dir AS '/home/oracle/dbdirect';
GRANT READ, WRITE ON DIRECTORY db_dir TO system;
Create Database Link:
CREATE DATABASE LINK src_db_link
CONNECT TO system IDENTIFIED BY password
USING 'localhost:1521/pdbsource';
Test DB Link:
SELECT * FROM dual@src_db_link;
EXPDP Command:
expdp system@pdbnew schemas=hr directory=db_dir network_link=src_db_link dumpfile=hr_net_%U.dmp logfile=exp_network.log parallel=2
IMPDP Command:
impdp system@pdbnew directory=db_dir dumpfile=hr_net_%U.dmp logfile=imp_network.log schemas=hr
🔹 Who should watch?
Oracle DBAs
Beginners learning Data Pump
Anyone preparing for Oracle interviews
👍 If you found this helpful, like, share, and subscribe for more Oracle DBA tutorials!
#Oracle #EXPDP #IMPDP #DataPump #OracleDBA #NetworkLink #DatabaseMigration #SQL