IMPDP - ORA-23327 (does Not Match GLOBAL NAME) On PRE_TABLE_ACTION (Doc ID 1568721.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to 12.1]
Oracle Database - Standard Edition - Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to 12.1]
Oracle Database - Personal Edition - Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to 12.1]
Information in this document applies to any platform.

Symptoms

You exported a table from the SYSTEM schema:

% expdp system/manager DIRECTORY=my_dir DUMPFILE=expdp_tab.dmp LOGFILE=expdp_tab.log TABLES=mytab

Export: Release 11.2.0.3.0 - Production on Tue Jul 23 10:35:33 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, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01":  system/******** DIRECTORY=my_dir DUMPFILE=expdp_tab.dmp LOGFILE=expdp_tab.log TABLES=mytab
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
. . exported "SYSTEM"."MYTAB"                            5.421 KB       2 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
  /DataPump/expdp_tab.dmp
Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at 10:35:51

When attempting to import the table from this table-level Export Data Pump dumpfile from the user SYSTEM, into a different database, the following error occurs:

% impdp system/manager DIRECTORY=my_dir DUMPFILE=expdp_tab.dmp LOGFILE=impdp_tab.log FULL=y

Import: Release 11.2.0.3.0 - Production on Tue Jul 23 13:35:33 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, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** DIRECTORY=my_dir DUMPFILE=expdp_tab.dmp LOGFILE=impdp_tab.log FULL=y
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 GLOBAL NAME of importing db
Failing sql is:
BEGIN
 SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('M11203XA.CH.ORACLE.COM','IBMPC/WIN_NT64-9.1.0');
 END;
...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "SYSTEM"."MYTAB"                            5.421 KB       2 rows
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 6 error(s) at 13:35:36

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms