This discussion is archived
2 Replies Latest reply: Oct 11, 2013 2:11 AM by DK2010 RSS

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

97ff9dfe-55d3-4543-8a2c-3864528deaaf Newbie
Currently Being Moderated

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....

Legend

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