Posts

Showing posts with the label ORA-39083

ORA-39083 ORA-02298 ORA-02374 ORA-1289 parent keys not found and value too large for column DESCRIPTION

Issue: While importing from 11.2.0.4 to 12.2.0.1 DB: ORA-39083: Object type REF_CONSTRAINT:"TEST"."TK_COD_TYPE" failed to create with error: ORA-02298: cannot validate (TEST.TK_COD_TYPE) - parent keys not found Failing sql is: ALTER TABLE "TEST"."CODE" ADD CONSTRAINT "TK_COD_TYPE" FOREIGN KEY ("TYPE") REFERENCES "TEST"."CODEAREA" ("CODEAREA") ENABLE ORA-39083: Object type REF_CONSTRAINT:"TEST"."TK_PDE_RPP_ID" failed to create with error: ORA-02298: cannot validate (TEST.TK_PDE_RPP_ID) - parent keys not found Failing sql is: ALTER TABLE "TEST"."PDE_RPP_RPT_PARAM" ADD CONSTRAINT "TK_PDE_RPP_ID" FOREIGN KEY ("RPT_ID") REFERENCES "TEST"."RPT_REPORT" ("RPT_ID") ENABLE ORA-39083: Object type REF_CONSTRAINT:"TEST"."TK_COD_TYPE" failed to create with error: ORA-02298: cannot vali...

ORA-39083: Object type TYPE:"AURTO"."NORES_DATA" failed to create with error: ORA-02304: invalid object identifier literal

ORA-39083: Object type TYPE:"AURTO"."NORES_DATA" failed to create with error: ORA-02304: invalid object identifier literal Command executed: impdp  SCHEMAS=PORTO remap_schema=PORTO:AURTO remap_tablespace=PORTO:AURTO directory=PRODIMP dumpfile=PROD_%U.dmp logfile=PORTO_imp.log parallel=5 Error received: ORA-39083: Object type TYPE:"AURTO"."NORES_DATA" failed to create with error: ORA-02304: invalid object identifier literal Failing sql is: CREATE EDITIONABLE TYPE "AURTO"."NORES_DATA"   OID '6EE61264420D2234E04400144FEDB040' AS OBJECT (   VAL              VARCHAR2(200) ) ORA-39083: Object type TYPE:"AURTO"."NORES_TABLE_TYPE" failed to create with error: ORA-02304: invalid object identifier literal Failing sql is: CREATE EDITIONABLE TYPE "AURTO"."NORES_TABLE_TYPE"   OID '6EE6126442112234E04400144FEDB930' AS TABLE OF NORES_data Cause: Trying to c...