补充:
1 IMPDP+network_link, 直接导入到目标库中(从dblink对应的远端库)
2 EXPDP+network_link,直接将远端库上的数据,导出到本地机器上
一、目标端
dblink
CREATE PUBLIC DATABASE LINK conn_old_11g
CONNECT TO system IDENTIFIED BY "oracle" USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.66.101)(PORT = 11521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = testdb)))';
directory :
create directory QN as '/home/db/oracle/from11g/QN';
创建用户并赋权限:
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TESTPDB READ WRITE NO
4 TESTPDB2 MOUNTED
5 MY_APP MOUNTED
6 SALESPDB2 MOUNTED
8 TESTPDB22 MOUNTED
9 SALESACT MOUNTED