ORA-00972: identifier is too long

Scenario :-

SQL> SELECT dbms_metadata.get_ddl('INDEX',’SMON_SCN_TIME_SCN_IDX’,'SYS') from dual;
SELECT dbms_metadata.get_ddl('INDEX',’SMON_SCN_TIME_SCN_IDX’,'SYS') from dual
                                     *
ERROR at line 1:
ORA-00972: identifier is too long

Cause: An object identifier was specified with more than 30 characters.
   
Action: Specify at most 30 characters.
                Make sure that Oracle object names are shorter than thirty characters.

we may experience this issue many times when we trying to access database column, alias, or table names which are too long which having large length. it can be cause ORA-00972.



------------------------           Thank you                -----------------------------------------