利用impdp+network从11g迁移数据到19c

补充：

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