Not Able To Create Sequence In Oracle 19.14 Version reporting ora-00972 error
(Doc ID 2881905.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Standard Edition - Version 19.14.0.0.0 and laterInformation 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 |