Dear All,

Is anyone aware of a way to compare Oracle databases (schemas and
content)? I found a .net software DBTyP.net that promises an easy and
visual comparison, but it seems not to be working with Oracle dbs
(though their site outlines it as one of the available options).

Thank you.
Agata

On Apr 1, 6:59*pm, AgataKrishtoff <agata0krisht... (AT) gmail (DOT) com> wrote:
I once wrote a routine to compare the contents of a table loaded with
the contents of dba_tab_columns from multiple databases. You could do
the same.

Tom Kyte has written about comparing tables to find differences so you
can probably find an article on this at http://asktom.oracle.com via
the search feature there.

select * from tableA minus select * from TableA@databaseB

HTH -- Mark D Powell --

On Apr 1, 6:59*pm, AgataKrishtoff <agata0krisht... (AT) gmail (DOT) com> wrote:
I once wrote a routine to compare the contents of a table loaded with
the contents of dba_tab_columns from multiple databases. You could do
the same.

Tom Kyte has written about comparing tables to find differences so you
can probably find an article on this at http://asktom.oracle.com via
the search feature there.

select * from tableA minus select * from TableA@databaseB

HTH -- Mark D Powell --

On Apr 1, 6:59*pm, AgataKrishtoff <agata0krisht... (AT) gmail (DOT) com> wrote:
I once wrote a routine to compare the contents of a table loaded with
the contents of dba_tab_columns from multiple databases. You could do
the same.

Tom Kyte has written about comparing tables to find differences so you
can probably find an article on this at http://asktom.oracle.com via
the search feature there.

select * from tableA minus select * from TableA@databaseB

HTH -- Mark D Powell --

On Apr 1, 6:59*pm, AgataKrishtoff <agata0krisht... (AT) gmail (DOT) com> wrote:
I once wrote a routine to compare the contents of a table loaded with
the contents of dba_tab_columns from multiple databases. You could do
the same.

Tom Kyte has written about comparing tables to find differences so you
can probably find an article on this at http://asktom.oracle.com via
the search feature there.

select * from tableA minus select * from TableA@databaseB

HTH -- Mark D Powell --

AgataKrishtoff wrote:
The capability is built into the database.

In versions prior to 11g use DBMS_RECTIFIER_DIFF
In 11g use DBMS_COMPARISON
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

AgataKrishtoff wrote:
The capability is built into the database.

In versions prior to 11g use DBMS_RECTIFIER_DIFF
In 11g use DBMS_COMPARISON
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

AgataKrishtoff wrote:
The capability is built into the database.

In versions prior to 11g use DBMS_RECTIFIER_DIFF
In 11g use DBMS_COMPARISON
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

AgataKrishtoff wrote:
The capability is built into the database.

In versions prior to 11g use DBMS_RECTIFIER_DIFF
In 11g use DBMS_COMPARISON
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Apr 2, 10:30 am, DA Morgan <damor... (AT) psoug (DOT) org> wrote:
Thank you!