Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMPDP || ORA-00904 || ORA-39083 Error in 12.2.0.1 database

007Mar 8 2020 — edited Mar 15 2020

Hi,

I am performing a datapump import impdp database version 12.2.0.1.0 database in Red Hat Enterprise Linux Server release 7.7. I am importing with REMAP SCHEMA=P2500PR:P2500TS option.

Facing the below error.

Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY

Processing object type SCHEMA_EXPORT/TYPE/TYPE_BODY

ORA-39083: Object type TABLE:"P2500TS"."MOZAM_QTM_000#RO" failed to create with error:

ORA-00904: "P2500PR"."PROCESS_DATE_C21": invalid identifier

Failing sql is:

ALTER TABLE "P2500TS"."MOZAM_QTM_000#RO" MODIFY ("DELIVERY_DATE" NUMBER(11,0) GENERATED ALWAYS AS (CAST("P2500PR"."DELIVERY_DATE_C21"(SYS_MAKEXML(0,"SYS_NC00003$")) AS NUMBER(11))) VIRTUAL )

ORA-39083: Object type TABLE:"P2500TS"."MOZAM_EB_CO1#RO" failed to create with error:

ORA-00904: "P2500PR"."DATE_RECENT_UPDATE_C21": invalid identifier

Is there any solution on this error or work around??

Regards,

007

Added on Mar 8 2020

#database-key-features, #export-import-sql-loader-external-tables

4 comments

787 views