...
| No Format | ||
|---|---|---|
| ||
SQL> conn system/manager@target
Connected.
SQL> select * from repoe.tables
minus
select * from repoe.tables@source
union all
select * from repoe.tables@source
minus
select * from repoe.tables
/
no rows selected
SQL> |
...
From this output, you can see, that one command, that was run on source database and changes 11 rows, created 11 single row changes. Replicate is not replicating commands, but only rows changed.
You can again check for any discrepancies during replication by following command:
| No Format | ||
|---|---|---|
| ||
SQL> conn system/manager@target Connected. SQL> select * from repoe.tables minus select * from repoe.tables@source union all select * from repoe.tables@source minus select * from repoe.tables / no rows selected SQL> |