Pre SQL / Oracle Create Table w/ insert statement
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
It appears that Alteryx is breaking up a single statement into two statements - this completes the script, but throws an error anyway.
Oracle DB.
--------------------------
create table test nologging as
select *
from table
where conditions
--------------------------
input data (1) is an alias translation.
then an error of "Executing PreSQL: "[script above]" : ORA - 00955: Name already used by an existing object
then another error "Error running PreSQL: "[script above]" : ORA - 00955: Name already used by an existing object
Designer message: Finished running in 2.3 seconds with 2 errors.
------------------------
When i check the schema, the table is created with data - so, Alteryx appears to be handling these correctly, but something about how Designer is performing this function is throwing errors even though it is completing. I suspect that Designer is unable having trouble with the create table with insert instead of setting up the table in step 1 and then inserting data in step 2, but I'm not sure.
I did run this script (and many others) directly through oracle with no issues.That's cluing me in to some issue with how Designer is executing.
Can anyone provide any insight on why these errors are throwing even though the script is completing?
Thank you.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Probably the table has already been created.
Drop the table and disable this input tool option if it is enabled.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Geraldo,
The table wasn't created prior to running the script (we tested multiple table iterations, test1, test2, test3, test4 - all come back with the same response.
I've dropped all the tables since they're just tests, and I'll try disabling the input tool.
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
worked great!
