Simple DML operations:
Prepare sample schema to replicate
With NODDL option
With DDL option
Creation of duplicate rows (potential conflict):
Create duplicate using 1 row DML
insert into repl_dba_tablespaces (select * from repl_dba_tablespaces where tablespace_name='TEMP');
update repl_dba_tablespaces set tablespace_name='TEMP2' where tablespace_name='TEMP';
List conflict
Show, how the problematic query transformed
Create duplicate using more rows DML
How many conflicts were created (1 conflict for 1 row) = >large transactions are separated into single rows
Resolve conflict
DML operation with trigger / constraint DML - show cascade constraint problem
SwingBench can now be started to produce a transaction load and simulate an order-entry system to test the replication.
...