Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Is it possible to Truncate an Oracle Table using In-Db?


We need to be able to do Truncate and Append as opposed to Delete and Append because Deleting the contents in the table takes too long.


Tried doing this In-Db but that didn't work.


In this thread:  Truncate Table Error Writing to SQL Database after 11.3 Upgrade the advice said to use the Pre Create SQL Statement and I was successful using Truncate:  TRUNCATE TABLE owner.table_name


However, I want to be able to do this while In-Database.  Is there any way to do that?