By default, the work performed by the maintenance user of
the primary connection is not replicated. The user ID used to insert
transactions cannot be the same as the maintenance user defined
in the primary connection.
Replication Agent applies only committed transactions to a
replicate database. However, because Oracle expects a commit command
to be issued, follow simple test commands with an explicit
commit command:
insert into T1 values ( 42, ‘foo’ );
commit;