Issue
Error "ORA-00918: column ambiguously defined" occurs when 2 tables with similar names are joined as shown below.
Last Modified Date: 08 Jul 2022
Environment
- Tableau Desktop
- Oracle
Resolution
Workaround
Use different table names less than 30 characters longCause
This is due to the Oracle (12.1 and earlier) design limitation on object name length.Part of the table names that are longer than 30 characters are truncated and end up as being ambiguous.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials