My Oracle Support Banner

Not Able To Create Sequence In Oracle 19.14 Version reporting ora-00972 error (Doc ID 2881905.1)

Last updated on JULY 25, 2022

Applies to:

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

Symptoms

On : 19.14.0.0.0 version, RDBMS

Not able to create Sequence in Oracle 19.14 version

CREATE SEQUENCE TEST_NOTICE_REGENERATION_MAPPING_SEQ START WITH 1 INCREMENT BY 1 NOCACHE ORDER;
Error report -
ORA-00972: identifier is too long
00972. 00000 - "identifier is too long"


One database  which is on RHEL7 server and having oracle version is 19.14 standard edition. Sequence created on this database without any issue.
On same server there is another database and having same oracle version and patches. But on this database same sequence query gives error.


ERROR
-----------------------
ORA-00972

Changes

 

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.