IssueWhen 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
ResolutionOption 1: Use extract instead of a live connection. Option 2: Redesign the join or custom SQL query to return fewer columns.
CauseError 1795 is a message from the Oracle database which is returned when more than 254 columns are specified to a list.
Additional InformationORA-01795: maximum number of expressions in a list is 1000 tips at DBA-Oracle.comORA-01795, limit on clause at Oracle community
Did this article resolve the issue? Thank you for providing your feedback on the effectiveness of the article. Click here to return to our Support page. Open new Case Open a new case Continue Searching Click here to go to our Support page. Knowledge Base Get detailed answers and how-to step-by-step instructions for your issues and technical questions. Community Find and share solutions with our active community through forums, user groups and ideas. Product Help Browse a complete list of product manuals and guides. Available online, offline and PDF formats. Training and Tutorials Learn how to master Tableau’s products with our on-demand, live or class room training.