Skip to main content
P
PascalDICHELLO1-Visitor
1-Visitor
November 1, 2012
Question

Error ORA-39083

  • November 1, 2012
  • 1 reply
  • 2825 views

Hello,

When I do an Import of the database Oracle 11.2.0.3 (Windchill 10.1 M020) when Roehosting, I get this error message :

ORA-39083

CREATE UNIQUE INDEX "WCHILL"."WTDOCUMENT$UNIQUE50" ON "WCHILL"."WTDOCUMENT" ("ID

A3MASTERREFERENCE", "VERSIONIDA2VERSIONINFO", "ITERATIONIDA2ITERATIONINFO", "WCH

ILL"."WIPPK"."GETNORMALIZEDWIPSTATE"("STATECHECKOUTINFO"), "ONEOFFVERSIONIDA2ONE

OFFVERSI") PCTFREE 10 INITRANS 2 MAXTRANS

I execute this command :

impdp xx/xx@target dumpfile=WTSCHEMA.DMP directory=directory SCHEMAS=source_schema logfile=imp.log

Does anyone an idea how to solve this problem ?

Thanks

    1 reply

    P
    ptc-44921861-Visitor
    1-Visitor
    November 28, 2012

    I would like to see logfile=imp.log to see it's progress. If it's not proceeding because of the above index then it needs to create that to WCHILL database. If it's already moved on than just need to place the missing index to the target database.

    M
    MorganBelais11-Garnet
    11-Garnet
    November 28, 2012

    I know that when we are rehosting we have a number of indexes that cannot be created, because the schema name is kept.

    Is WCHILL the source or target schema name ?

    In our case we are just creating the missing indexes after the rehosting.

    P
    PascalDICHELLO1-VisitorAuthor
    1-Visitor
    November 28, 2012

    the source is : WCHILL. and the traget is : WCHILL the same

    How did you create the missing indexes ?

    Terms & ConditionsAccessibility statement