"ORA-00972: identifier is too long" error when using long alias names for columns imported from Oracle Database

Created
October 08, 2021 23:24

Date Posted: 2018-09-26
Product: TIBCO Spotfire®

Problem:

Solution:

When you try to give a very long alias names to a column in a custom query(Oracle connector) it may fail to verify with the following error message.
--------------------
External error:
ORA-00972: identifier is too long
--------------------

Example Query: select X as yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy from test1.test2 This error message is generated from ORACLE database due to long name with morethan 30 characters. Make sure the alias name of a column is less than 30 characters.

Note: ORA-00972 can also be caused by column, alias, or table names which are too long (morethan 30 characters).