ORA-39083 and ORA-04007 when Altering Identity Column
(Doc ID 2663842.1)
Last updated on AUGUST 06, 2021
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
After installation of DATABASE BUNDLE PATCH 184.108.40.206.190716 or higher DBBP, user is unable to change Identity column after initial creation.
This is also affecting data pump import, although it occurs without import as well. The problem is not occurring on PSU's.
During import, the following errors would be observed:
ORA-39083: Object type IDENTITY_COLUMN:"OWNER" failed to create with error:
ORA-04007: MINVALUE cannot be made to exceed the current value
Applied DATABASE BUNDLE PATCH 220.127.116.11.190716 or higher DBBP. This does not effect PSU's.
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