KNOWLEDGE BASE

Error "ORA-00972: identifier is too long"


Published: 05 Dec 2013
Last Modified Date: 19 Apr 2017

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.

Cause

The ORA-00972 error originates from the Oracle database and not from Tableau Desktop. This error message indicates that an object within the Oracle database exceeds 30 characters. 
Did this article resolve the issue?