This content has been marked as final. Show 1 reply
You can refer below doc:
How To Setup One-Way SCHEMA Level Streams Replication (Doc ID 301431.1)
-The sample code replicates both DML and DDL.
And for capturing only DML statemenets you can set include_ddl to false in the below code. Other than this the setup is same.
schema_name => 'HR',
streams_type => 'APPLY ',
streams_name => 'STREAM_APPLY',
queue_name => 'STRMADMIN.STREAMS_QUEUE',
include_dml => true,
include_ddl => true,
source_database => 'STRM1.NET');