2 Replies Latest reply: Jun 19, 2013 6:59 AM by jamorcillov RSS

    impdp failed raising ORA-39083 and ORA-23327 importing thru network

    jamorcillov

      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é

        • 1. Re: impdp failed raising ORA-39083 and ORA-23327 importing thru network
          DK2010

          Hi,

           

          oracle not recommended  import the SYSTEM/SYS objects, you are going to higher version. It would be better to use the schema level export/import.

           

          you can ignore that system schema errors

          HTH

          • 2. Re: impdp failed raising ORA-39083 and ORA-23327 importing thru network
            jamorcillov

            ok!

             

            I run the same test case but creating the table under a normal user and:

             

             

             

             

            Import: Release 11.2.0.3.0 - Production on Wed Jun 19 13:16:15 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_BSOURCE_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

            . . imported <tabla>                                 5 rows

            Job "SYSTEM"."SYS_IMPORT_TABLE_01" successfully completed at 13:16:29





            Perfect!

             

            Thank you very much!

            José