ORA-39083 and ORA-04007 when Altering Identity Column
(Doc ID 2663842.1)
Last updated on NOVEMBER 04, 2020
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
After installation of DATABASE BUNDLE PATCH 22.214.171.124.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 126.96.36.199.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