Issue
When you try to use an object from the Oracle database (for example, column or table) with a name that is longer than thirty (30) characters, the following error might occur:Oracle database error 972: ORA-00972: identifier is too long
Last Modified Date: 21 Apr 2023
Environment
- Tableau Desktop
- Oracle
Resolution
Make sure that Oracle object names are shorter than thirty characters. The underlying Tableau SQL query is available to view by several methods shown in this article.Cause
The ORA-00972 error indicates that an object within the Oracle database exceeds 30 characters.Additional Information
ORA-00972: identifier is too longOracle Tutorial
Identifier Name Length and Uniqueness
Viewing Underlying SQL Queries
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials