Home Privacy Policy Feedback Link to us Site Map

Oracle/PLSQL: ORA-00972 Error


Error:

ORA-00972: identifier is too long

Cause:

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

Action:

The options to resolve this Oracle error are:
  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.