This discussion is archived
4 Replies Latest reply: May 22, 2013 8:41 AM by DK2010 RSS

IMPDP in oracle 11g

1010425 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points