Published: 05 Dec 2013 Last Modified Date: 21 Apr 2023
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
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.