KNOWLEDGE BASE

Oracle Table Name Containing Dollar Sign Not Found


Published: 06 Dec 2013
Last Modified Date: 10 May 2016

Issue

When connecting to an Oracle database tables with names that contain a dollar sign are not available.

Environment

  • Tableau Desktop
  • Oracle

Resolution

Remove all dollar signs from the Oracle table name.

Cause

Tableau Desktop explicitly filters out tables with names that contain dollar signs '$', forward slashes '/', or start with '#Tableau'.

Additional Information

Oracle strongly recommends against using dollar signs in non-quoted identifiers (an identifier that is not surrounded by any punctuation) when naming database objects. Oracle also does not recommend using quoted identifiers for database object names.

See Database Object Names and Qualifiers from Oracle's knowledge base for more information.
Did this article resolve the issue?