Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Finnova
Contributor III
Contributor III

Implement alter table truncate partition from Oracle

Hello

Actually, the alter table truncate partition-Statements from Oracle as Source are not part of the CDC replication. Are there plans to implement this?

Kind Regards

Labels (3)
1 Solution

Accepted Solutions
Dana_Baldwin
Support
Support

Hi @Finnova 

Truncate operations are not written to the Oracle redo logs for the task to be able to read them. One of the purposes of the truncate command is to empty an object quickly without the overhead of logging the event or capturing rollback data.

Thanks,

Dana

View solution in original post

1 Reply
Dana_Baldwin
Support
Support

Hi @Finnova 

Truncate operations are not written to the Oracle redo logs for the task to be able to read them. One of the purposes of the truncate command is to empty an object quickly without the overhead of logging the event or capturing rollback data.

Thanks,

Dana