View Revisions: Issue #6883

All RevisionsBack to Issue
Summary 0006883: Capture TRUNCATE table (schema-level) events in Oracle database
Revision 2025-05-11 19:32 by pbelov
Steps To Reproduce Set up a node with Oracle database as a source.

Create a test table :
   CREATE TABLE demo_small(id int);

Configure new SymmetricDS trigger for the demo_small table.

Set the parameter
trigger.capture.ddl.changes=true

Add test data:
   insert into demo_small values (1);
   select * from demo_small

Execute truncate statement:
   TRUNCATE TABLE demo_small;

Observe: No new sym_data records and old data (id=1) had not been deleted at the target.
  select * from demo_small
Revision 2025-05-09 18:40 by pbelov
Steps To Reproduce Set up a node with Oracle database as a source.
Set the parameter
trigger.capture.ddl.changes=true

Create a test table :
   CREATE TABLE demo_small(id int);

Configure new SymmetricDS trigger for the demo_small table.

Execute truncate statement:
   TRUNCATE TABLE demo_small;

Observe: No new sym_data records.