My Oracle Support Banner

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 12.1.0.2 and later
Information 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


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