View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006883 | SymmetricDS | New Feature | public | 2025-05-09 18:40 | 2025-05-09 18:41 |
| Reporter | pbelov | Assigned To | pbelov | ||
| Priority | normal | ||||
| Status | confirmed | Resolution | open | ||
| Product Version | 3.16.0 | ||||
| Target Version | 3.16.3 | ||||
| Summary | 0006883: Capture TRUNCATE table 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. 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. | ||||
| 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. | ||||