How to resolve ORA-00972 Error Message in Oracle database

Learn the cause and how to resolve the ORA-00972 error message in Oracle.


When you come across an ORA-00972 error, the following error message will appear:

ORA-00972: identifier is too long


You tried to reference a table, cluster, view, index, synonym, tablespace, or username with a price that was longer than 30 characters.


The option(s) to resolve this Oracle error are:

Option #1

Names for tables, clusters, views, indexes, synonyms, tablespaces, and usernames ought to be 30 characters or less. You must shorten the name to no more than 30 characters for these objects.