Impdp Fails with ORA-39083 for IDENTITY_COLUMN
(Doc ID 2578690.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
DataPump import (impdp) fails with ORA-39083 when processing IDENTITY_COLUMN:
...
Processing object type SCHEMA_EXPORT/TABLE/IDENTITY_COLUMN
ORA-39083: Object type IDENTITY_COLUMN:"<NAME>" failed to create with error:
ORA-00942: table or view does not exist
Failing sql is:
ALTER TABLE "<NAME>"."BIN$jd7pNhHWBM3gU2YvsoI3bg==$0" MODIFY ("NAME_ID" GENERATED ALWAYS AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH LIMIT VALUE CACHE 20 NOORDER NOCYCLE )
ORA-39083: Object type IDENTITY_COLUMN:"<NAME>" failed to create with error:
ORA-00942: table or view does not exist
Failing sql is:
ALTER TABLE "<NAME>"."BIN$jd7pNhHiBM3gU2YvsoI3bg==$0" MODIFY ("NAME_ID" GENERATED ALWAYS AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH LIMIT VALUE CACHE 20 NOORDER NOCYCLE )
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
....
Processing object type SCHEMA_EXPORT/TABLE/IDENTITY_COLUMN
ORA-39083: Object type IDENTITY_COLUMN:"<NAME>" failed to create with error:
ORA-00942: table or view does not exist
Failing sql is:
ALTER TABLE "<NAME>"."BIN$jd7pNhHWBM3gU2YvsoI3bg==$0" MODIFY ("NAME_ID" GENERATED ALWAYS AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH LIMIT VALUE CACHE 20 NOORDER NOCYCLE )
ORA-39083: Object type IDENTITY_COLUMN:"<NAME>" failed to create with error:
ORA-00942: table or view does not exist
Failing sql is:
ALTER TABLE "<NAME>"."BIN$jd7pNhHiBM3gU2YvsoI3bg==$0" MODIFY ("NAME_ID" GENERATED ALWAYS AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH LIMIT VALUE CACHE 20 NOORDER NOCYCLE )
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
....
Changes
N/A
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |