My Oracle Support Banner

ORA-39083 and ORA-04007 when Altering Identity Column (Doc ID 2663842.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


After installation of DATABASE BUNDLE PATCH 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 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

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