KNOWLEDGE BASE

Error "Oracle database error 1795: ORA-01795: maximum number of expressions in a list is 1000 "


Published: 21 Aug 2015
Last Modified Date: 30 Nov 2017

Issue

When you try to create a join or open a workbook containing custom SQL, the following error might occur: 
Oracle database error 1795: ORA-01795: maximum number of expressions in a list is 1000

Environment

  • Tableau Desktop
  • Oracle

Resolution

Option 1: 

Use extract instead of a live connection.

Option 2: 

Redesign the join or custom SQL query to return fewer columns. 

Cause

Error 1795 is a message from the Oracle database which is returned when more than 254 columns are specified to a list. 
Did this article resolve the issue?