"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
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).
Issue/Introduction
Unable to use long alias names for columns imported via Oracle connector custom query
Feedback
Yes
No
Powered by
