Sunday, May 4, 2014

ORA-00972: identifier is too long

SQL> Select * from identifier_too_long_cause_extends_30;
Select * from identifier_too_long_cause_extends_30
              *
ERROR at line 1:
ORA-00972: identifier is too long


Cause : Oracle identifiers are not allowed to exceed 30 characters in length.

Solution : Please use Table name (object name) between 1 to 30 character long.

No comments:

Post a Comment