oracle error messages

Oracle/PLSQL: ORA-00972

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


When you encounter 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 value 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 must be 30 characters or less. You must shorten the name to no more than 30 characters for these objects.