Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
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