Alteryx designer Discussions

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

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

Highlighted
Asteroid

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?

 

Thanks

 

 

Labels