My Oracle Support Banner

Impdp Fails With ORA-39083 For IDENTITY_COLUMN (Doc ID 2578690.1)

Last updated on NOVEMBER 29, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information 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
....



Changes

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.