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
Cause of Error
You tried to reference a table, cluster, view, index, synonym, tablespace, or username with a value that was longer than 30 characters.
How to Resolve the Error
The option(s) to resolve this Oracle error are:
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.