Adsense Ad

Thursday 25 May 2017

Oracle: ORA-00972 Error Message

ORA-00972 Error Message

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

Description

When you encounter an ORA-00972 error, the following error message will appear:
  • 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.

Resolution

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.

No comments: