3 Replies Latest reply on Oct 26, 2013 2:14 PM by Robert Morton

    ORA-00604: error occurred at recursive SQL level 1 because of tableau temp tables

    Praveen N



      I am using custom sql (a simple left outer join) to query oracle db and it is a ready only DB.I am able execute query on sql developer. But when I use the same through tableau, tableau wrappers my query with some customization and creating some temp tables I guess. And finally when it runs the query, I get


      “Oracle database error 604: ORA-00604: error occurred at recursive SQL level 1: ORA-16000: database open for read-only access”


      Does this mean when creating a data connection in Tableau, I have to use an account which has write access to the source database?


      I don’t think to just ready the data, we need write access just because tableau runs some temp queries.


      Am I missing anything? How do I resolve this error?Any help on this is highly appreciated. Thanks in advance.