DML Issued by DDL Trigger is not Replicated with Streams
(Doc ID 880658.1)
Last updated on JANUARY 30, 2022
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
-- Problem Statement:
Under a special scenario, some updates from DML triggers are not being captured and applied in streams environments. When having replicated table with streams (DDL and DML), if we have DML trigger on this table, and this trigger has been fired by any DDL statement (like alter table add column for example) , the DML changes by the DML trigger will not be able to replicate to the target table, please see the following example :
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document