4 Replies Latest reply on May 22, 2013 3:41 PM by DK2010

    IMPDP in oracle 11g

    1010425
      I want to import 'data_only' into 11 oracle schemas from exp file while remapping 4 schemas. I tried below command:
      impdp system/bluelou dumpfile=exp_database.dmp logfile=import_database.log REMAP_SCHEMA=old_schema1:new_schema1,old_schema2:new_schema2,
      old_schema3:new_schema3..................old_schema11:new_schema11 grants=y conent_data_only

      And i realized that I dont have 'data_only' option in remap:schema. can some one advice how to handle this?
        • 1. Re: IMPDP in oracle 11g
          sb92075
          1007422 wrote:
          I want to import 'data_only' into 11 oracle schemas from exp file while remapping 4 schemas. I tried below command:
          impdp system/bluelou dumpfile=exp_database.dmp logfile=import_database.log REMAP_SCHEMA=old_schema1:new_schema1,old_schema2:new_schema2,
          old_schema3:new_schema3..................old_schema11:new_schema11 grants=y conent_data_only

          And i realized that I dont have 'data_only' option in remap:schema. can some one advice how to handle this?
          what do you expect/desire should occur when no object exists to accept the imported data?
          • 2. Re: IMPDP in oracle 11g
            1010425
            Thanks for the reply.

            I just want to ignore/blow an error saying so and so object is not exists if no object found.
            • 3. Re: IMPDP in oracle 11g
              1010425
              I dont want to create a missing table/structure in destination schema. do we have any impdp parameter to skip it?




              Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
              With the Partitioning, OLAP, Data Mining and Real Application Testing options
              Legacy Mode Active due to the following parameters:
              Legacy Mode Parameter: "grants=TRUE" Location: Command Line, ignored.
              Legacy Mode Parameter: "ignore=TRUE" Location: Command Line, Replaced with: "table_exists_action=append"
              Master table "SYSTEM"."SYS_IMPORT_SCHEMA_02" successfully loaded/unloaded
              Starting "SYSTEM"."SYS_IMPORT_SCHEMA_02": system/******** dumpfile=exp_database_gcadev-131605.dmp logfile=import_database_gcadev_2013052210241354.implog schemas=KEYNOX_FX,TRANSNOX_WM,TRANSNOX_GLORY,SNOX4TRANSNOX_GCA,SNOX4TRANSNOX,TRANSNOX_GCA,TRANSNOX_RECON content=data_only table_exists_action=append
              Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
              ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UPATE_TD_ROW_IMP [112]
              TABLE_DATA:"KEYNOX_FX"."DDL_SCRIPTS"
              ORA-31603: object "DDL_SCRIPTS" of type TABLE not found in schema "KEYNOX_FX"

              ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
              ORA-06512: at "SYS.KUPW$WORKER", line 8170

              ----- PL/SQL Call Stack -----
              object line object
              handle number name
              0x625ca700 19028 package body SYS.KUPW$WORKER
              0x625ca700 8191 package body SYS.KUPW$WORKER
              0x625ca700 18608 package body SYS.KUPW$WORKER
              0x625ca700 4104 package body SYS.KUPW$WORKER
              0x625ca700 8874 package body SYS.KUPW$WORKER
              0x625ca700 1651 package body SYS.KUPW$WORKER
              0x657f41d0 2 anonymous block

              ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UPATE_TD_ROW_IMP [112]
              TABLE_DATA:"KEYNOX_FX"."DDL_SCRIPTS"
              ORA-31603: object "DDL_SCRIPTS" of type TABLE not found in schema "KEYNOX_FX"

              ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
              ORA-06512: at "SYS.KUPW$WORKER", line 8170

              ----- PL/SQL Call Stack -----
              object line object
              handle number name
              0x625ca700 19028 package body SYS.KUPW$WORKER
              0x625ca700 8191 package body SYS.KUPW$WORKER
              0x625ca700 18608 package body SYS.KUPW$WORKER
              0x625ca700 4104 package body SYS.KUPW$WORKER
              0x625ca700 8874 package body SYS.KUPW$WORKER
              0x625ca700 1651 package body SYS.KUPW$WORKER
              0x657f41d0 2 anonymous block

              Job "SYSTEM"."SYS_IMPORT_SCHEMA_02" stopped due to fatal error at 10:14:38
              • 4. Re: IMPDP in oracle 11g
                DK2010
                Hi,

                seem you are confused, as your first post you want to use REMAP_SCHEMA and in this post you are only import schemas
                What you actually want to do, you are using content=data_only table_exists_action=append

                And in your logs shows table does not exist. first create the table there or remove the parameter content=data_only if you have export dump with option CONTENT=ALL
                and make sure you have the respective table in that schema
                chekc this link may it help you
                http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php