Data Output to Oracle: Create Table - Unable

Hi. When attempting to output to Oracle, I choose the "Create New Table" option, and specify a table name as "[schema].test21". On running the workflow, I get the following error msg: "DataWrapOCI: Unable to prepare the Create Table Statement: "Create Table..." [etc]. I do have Create Table permissions in Oracle, and the same Create Table statement succeeds when I run it in another Oracle client. Here's a screenshot. What do I do to overcome this? Thank you.

OCI Error Pic.jpg

Database Connection

Accepted answers

DanielUpton

Hi Jessica.

Solved my own problem this time. The error statement doesn't specify it, but since I specified in Alteryx "Create Table" vs. 'Overwrite Table (Drop)" or "Append", etc., the workflow failed on the second run, since a table of that name was already created on my first run.