Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Receive error "ORA-00942 - table or view does not exist" or "ORA-00903 - invalid table name" using output mode to "Append Existing" even though the table exists

ntobon
Alteryx
Alteryx
Created

Issue

I run a workflow with Write Data In-DB tool configured with Output Mode "Append Existing" and I get "Error: ORA-00942: table or view does not exist" or "ORA-00903 - invalid table name" even though the Oracle table exists. Why?
 

Error: Write Data In-DB (2): DataWrapOCI: Unable to prepare the query: "SELECT * FROM "sysdate_table"" Error: ORA-00942: table or view does not exist
 

Environment Details

 
  • Alteryx Designer
    • All Versions.
  • Oracle database


Cause

 

Incorrect Quote Identifier for the database specified in the In-DB connection tool. 



Resolution

 

Make sure the In-DB connection is configured to both read and write 'Quoted'. 



Additional Resources

No ratings