Hi friends!
Source: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 under HP-UX
Target: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production under Linux 2.6.18-238.el5
The import sentence is very simple:
impdp system tables=<tabla> NETWORK_LINK=DSN_LINK_HP
and log:
Import: Release 11.2.0.3.0 - Production on Wed Jun 19 12:13:18 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP and Data Mining options
Starting "SYSTEM"."SYS_IMPORT_TABLE_01": system/******** tables=<tabla> NETWORK_LINK=DSN_LINK_HP
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/PRE_TABLE_ACTION
ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match platform of importing db
Failing sql is:
BEGIN
SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('BDSOURCE','IA64/HPUX 64.0.9.0.1');
END;
ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match platform of importing db
Failing sql is:
BEGIN
SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('BDSOURCE','IA64/HPUX 64.0.9.0.1');
END;
ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match platform of importing db
Failing sql is:
BEGIN
SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('BDSOURCE','IA64/HPUX 64.0.9.0.1');
END;
ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match platform of importing db
Failing sql is:
BEGIN
SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('BDSOURCE','IA64/HPUX 64.0.9.0.1');
END;
ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match platform of importing db
Failing sql is:
BEGIN
SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('BDSOURCE','IA64/HPUX 64.0.9.0.1');
END;
ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match platform of importing db
Failing sql is:
BEGIN
SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('BDSOURCE','IA64/HPUX 64.0.9.0.1');
END;
. . imported "SYSTEM"."<tabla>" 3 rows
Job "SYSTEM"."SYS_IMPORT_TABLE_01" completed with 6 error(s) at 12:13:36
This is a test case but we want to use it to export/import to a different platform.
After de impdp <tabla> was imported corrected but I want to know we that errors were raised!
Thank you very much!
José