Oracle 10g impdp跨网络导数据

本测试的亮点是impdp参数network_link，此参数支持跨Oracle版本（如10.2.0.4和10.2.0.3），跨操作系统。
测试库
ora10g@mcprod ~]$ export ORACLE_SID=mcstar
ora10g@mcprod ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Nov 16 14:32:11 2010

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> conn zhou/zhou
Connected.
生产库
[ora10g@hzmc ~]$ export ORACLE_SID=drb
[ora10g@hzmc ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Nov 16 15:05:31 2010

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> conn system/oracle;
Connected.

SQL> create database link mcstar connect to zhou identified by zhou using 'mcstar';

Database link created.

SQL> conn /as sysdba;
Connected.

SQL>  drop user zhou cascade;

User dropped.

SQL> CREATE DIRECTORY dmpdir AS '/tmp';

Directory created.

SQL>  GRANT read, write ON DIRECTORY dmpdir TO system;

Grant succeeded.

SQL> create tablespace zhou datafile '/Tbackup/mcstar/oradata/zhou02.dbf' size 50m;

Tablespace created.

[ora10g@hzmc tmp]$ impdp system/oracle@drb directory=dmpdir network_link=mcstar schemas=zhou

Import: Release 10.2.0.3.0 - Production on Tuesday, 16 November, 2010 15:28:51

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":  system/********@drb directory=dmpdir network_link=mcstar schemas=zhou
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 372 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . imported "ZHOU"."T2"                                  46285 rows
. . imported "ZHOU"."TABLE_AFTER"                        759248 rows
. . imported "ZHOU"."TABLE_BEFORE"                       759248 rows
. . imported "ZHOU"."TESTT1"                             181860 rows
. . imported "ZHOU"."T"                                  189812 rows
. . imported "ZHOU"."T1"                                  46284 rows
. . imported "ZHOU"."ZHOU"                                    0 rows
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully completed at 15:33:00

注：在跨版本，跨操作系统中可能存在某些bug
[ora10g@hzmc admin]$ impdp system/oracle@drb directory=dmpdir network_link=ora10g schemas=zhou

Import: Release 10.2.0.3.0 - Production on Tuesday, 16 November, 2010 15:58:24

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_02":  system/********@drb directory=dmpdir network_link=ora10g schemas=zhou
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 4 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS while calling DBMS_METADATA.CLOSE []
ORA-31600: invalid input value 200002 for parameter HANDLE in function CLOSE

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6228

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x2be1375c     14916  package body SYS.KUPW$WORKER
0x2be1375c      6293  package body SYS.KUPW$WORKER
0x2be1375c      6988  package body SYS.KUPW$WORKER
0x2be1375c      1259  package body SYS.KUPW$WORKER
0x2de75438         2  anonymous block