"ORA-00972: identifier is too long" error when using long alias names for columns imported from Oracle Database
Article ID: KB0080643
Updated On:
| Products | Versions |
|---|---|
| Spotfire Connector for Oracle | All Supported Versions |
Description
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
--------------------
External error:
ORA-00972: identifier is too long
--------------------
Example Query: select X as yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy from test1.test2
Issue/Introduction
Unable to use long alias names for columns imported via Oracle connector custom query
Environment
All Supported Environments
Resolution
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).
Note: ORA-00972 can also be caused by column, alias, or table names which are too long (morethan 30 characters).
Feedback
Yes
No
Powered by
