ORA-39083 and ORA-04007 when Altering Identity Column
(Doc ID 2663842.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
After installation of DATABASE BUNDLE PATCH 12.1.0.2.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
Changes
Applied DATABASE BUNDLE PATCH 12.1.0.2.190716 or higher DBBP. This does not effect PSU's.
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 |