DataPump Import (IMPDP) Reports ORA-39083 And ORA-25158 For Referential Constraints (Doc ID 2260082.1)

Last updated on MAY 16, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

When performing a Data Pump import, the import job fails to create the referential constraints due to ORA-25158:

Import: Release 12.1.0.2.0 - Production on Thu Apr 6 13:53:04 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01": sys/******** AS SYSDBA directory=rdf_exp_imp_ofsaadev dumpfile=expdp_FCT_COMMON_ACCOUNT_SUMMARY_%U.dmp logfile=impFCT_COMMON_ACCOUNT_SUMMARY_0406.log parallel=3 table_exists_action=replace
Processing object type TABLE_EXPORT/TABLE/TABLE
...
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
ORA-39083: Object type REF_CONSTRAINT:"RDFATOMIC"."FK_180_1" failed to create with error:
ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY
Failing sql is:
ALTER TABLE "RDFATOMIC"."FCT_COMMON_ACCOUNT_SUMMARY" ADD CONSTRAINT "FK_180_1" FOREIGN KEY ("N_PRODUCT_SKEY") REFERENCES "RDFATOMIC"."DIM_PRODUCT" ("N_PROD_SKEY") RELY ENABLE NOVALIDATE
ORA-39083: Object type REF_CONSTRAINT:"RDFATOMIC"."FK_180_10" failed to create with error:
ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY
Failing sql is:
ALTER TABLE "RDFATOMIC"."FCT_COMMON_ACCOUNT_SUMMARY" ADD CONSTRAINT "FK_180_10" FOREIGN KEY ("N_PLEDGED_STATUS") REFERENCES "RDFATOMIC"."DIM_PLEDGED_STATUS" ("N_PLEDGED_STATUS") RELY ENABLE NOVALIDATE
ORA-39083: Object type REF_CONSTRAINT:"RDFATOMIC"."FK_180_11" failed to create with error:
ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY
Failing sql is:
ALTER TABLE "RDFATOMIC"."FCT_COMMON_ACCOUNT_SUMMARY" ADD CONSTRAINT "FK_180_11" FOREIGN KEY ("N_DATA_SOURCE_CD") REFERENCES "RDFATOMIC"."DIM_DATA_ORIGIN" ("N_DATA_SOURCE_CD") RELY ENABLE NOVALIDATE
ORA-39083: Object type REF_CONSTRAINT:"RDFATOMIC"."FK_180_12" failed to create with error:
ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY
Failing sql is:
ALTER TABLE "RDFATOMIC"."FCT_COMMON_ACCOUNT_SUMMARY" ADD CONSTRAINT "FK_180_12" FOREIGN KEY ("N_AMRT_TYPE") REFERENCES "RDFATOMIC"."DIM_AMORTIZATION_TYPE" ("N_AMRT_TYPE") RELY ENABLE NOVALIDATE
ORA-39083: Object type REF_CONSTRAINT:"RDFATOMIC"."FK_180_13" failed to create with error:
ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY
Failing sql is:
ALTER TABLE "RDFATOMIC"."FCT_COMMON_ACCOUNT_SUMMARY" ADD CONSTRAINT "FK_180_13" FOREIGN KEY ("N_DAY_COUNT_IND") REFERENCES "RDFATOMIC"."DIM_DAY_COUNT_IND" ("N_DAY_COUNT_IND") RELY ENABLE NOVALIDATE
ORA-39083: Object type REF_CONSTRAINT:"RDFATOMIC"."FK_180_14" failed to create with error:
ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY
Failing sql is:
ALTER TABLE "RDFATOMIC"."FCT_COMMON_ACCOUNT_SUMMARY" ADD CONSTRAINT "FK_180_93" FOREIGN KEY ("N_NETTING_AGREEMENT_SKEY") REFERENCES "RDFATOMIC"."DIM_NETTING_AGREEMENT" ("N_NETTING_AGREEMENT_SKEY") RELY ENABLE NOVALIDATE
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job "SYS"."SYS_IMPORT_FULL_01" completed with 93 error(s) at Tue Apr 4 11:26:02 2017 elapsed 0 00:09:15

 

Changes

 None

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms