View Issue Details

IDProjectCategoryView StatusLast Update
0006883SymmetricDSNew Featurepublic2025-06-08 01:07
Reporterpbelov Assigned Topbelov  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.16.0 
Target Version3.16.3Fixed in Version3.16.3 
Summary0006883: Capture TRUNCATE table (schema-level) events in Oracle database
DescriptionThe Oracle database supports triggers for TRUNCATE table events and reports it as a schema-level event.
Currently these events are not being captured by the existing DDL trigger feature.

The TRUNCATE table event in Oracle is:
* A schema-level event (not a row-level or table-level event).
* Could be added to the existing DDL trigger feature.

Consider: "create or replace trigger $(triggerName) after ddl OR truncate on schema\n"
Steps To ReproduceSet 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

Additional InformationOracle docs:
Create Trigger https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/CREATE-TRIGGER-statement.html
TagsNo tags attached.

Activities

pbelov

2025-05-11 19:55

manager   ~0002955

Opened PR https://github.com/JumpMind/symmetric-ds/pull/275

pbelov

2025-06-08 01:07

manager   ~0003032

Included in the 3.16.3 release

Related Changesets

SymmetricDS: 3.16 410ef0b2

2025-05-14 14:51:21

pbelov


Committer: GitHub Details Diff
0006883: Capture TRUNCATE table (schema-level) events in Oracle database (0000275)

0006883: Capture TRUNCATE table (schema-level) events in Oracle database
Affected Issues
0006883
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleTriggerTemplate.java Diff File

Issue History

Date Modified Username Field Change
2025-05-09 18:40 pbelov New Issue
2025-05-09 18:40 pbelov Status new => assigned
2025-05-09 18:40 pbelov Assigned To => pbelov
2025-05-09 18:41 pbelov Status assigned => confirmed
2025-05-11 19:32 pbelov Steps to Reproduce Updated View Revisions
2025-05-11 19:51 pbelov Summary Capture TRUNCATE table events in Oracle database => Capture TRUNCATE table (schema-level) events in Oracle database
2025-05-11 19:55 pbelov Status confirmed => assigned
2025-05-11 19:55 pbelov Note Added: 0002955
2025-05-14 14:50 pbelov Status assigned => resolved
2025-05-14 14:50 pbelov Resolution open => fixed
2025-05-14 14:50 pbelov Fixed in Version => 3.16.3
2025-05-14 15:00 pbelov Changeset attached => SymmetricDS 3.16 410ef0b2
2025-06-08 01:07 pbelov Note Added: 0003032
2025-06-08 01:07 pbelov Status resolved => closed