Versions Compared

Old Version 8

changes.mady.by.user Petr Horejs

Saved on

compared with

New Version 9

changes.mady.by.user Petr Horejs

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

No Format
languagesql
SQL> conn system/manager@target
Connected.
select * from repoe.tables
minus
select * from repoe.tables@source
union all
select * from repoe.tables@source
minus
select * from repoe.tables
/

no rows selectedSQL> selected


SQL> 

This query uses database link created before and checks for any rows, that are in source database and are not present in target database and vice versa. If it returns some rows, than something bad happened.