View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0006883 | SymmetricDS | New Feature | public | 2025-05-09 18:40 | 2025-06-08 01:07 |
Reporter | pbelov | Assigned To | pbelov | ||
Priority | normal | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.16.0 | ||||
Target Version | 3.16.3 | Fixed in Version | 3.16.3 | ||
Summary | 0006883: Capture TRUNCATE table (schema-level) events in Oracle database | ||||
Description | The 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 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 | ||||
Additional Information | Oracle docs: Create Trigger https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/CREATE-TRIGGER-statement.html | ||||
Tags | No tags attached. | ||||
SymmetricDS: 3.16 410ef0b2 2025-05-14 14:51:21 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 |
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 |