2 Replies Latest reply: Oct 11, 2013 4:11 AM by DK2010 RSS

    impdp using Remap schema throws error ORA-39083 and ORA-00942.

    97ff9dfe-55d3-4543-8a2c-3864528deaaf

      Hi,

      I am quiet new to oracle export/import datapump utility.

      I want to import a oracle database in different schema , following is the details

       

       

      SOURCE SCHEMA : wcadmin10

      EXPORT COMMAND: expdp system/********@wind SCHEMAS=wcadmin10 DIRECTORY=dpump_dir_client DUMPFILE=wcadmin10.DMP logfile=wcadmin10exp.log EXCLUDE=STATISTICS

       

      TARGET SCHEMA: wcadmin10_reh

      IMPORT COMMAND: impdp system/********@wind directory=dpump_dir_client dumpfile=wcadmin10.DMP logfile=wcadmin10imp.log remap_schema=wcadmin10:wcadmin10_reh transform=OID:n

       

      The above import command throws the following errors,

      ORA-39083: Object type INDEX failed to create with error:

      ORA-00942: table or view does not exist

      Failing sql is:

      CREATE UNIQUE INDEX "WCADMIN10_REH"."REQUIREMENT$UNIQUE50" ON "WCADMIN10_REH"."REQUIREMENT" ("IDA3MASTERREFERENCE", "VERSIONIDA2VERSIONINFO", "ITERATIONIDA2ITERATIONINFO", "WCADMIN10"."WIPPK"."GETNORMALIZEDWIPSTATE"("STATECHECKOUTINFO"), "ONEOFFVERSIONIDA2ONEOFFVERSI") PCTFREE 10 INITRANS 2 MAXTRANS 255  STORAGE(INITIAL 24576 NEXT 24576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELIST

       

      Kindly help on this issue....