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 126.96.36.199.0 and later
Information in this document applies to any platform.
On : 188.8.131.52.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.
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