Re: How to compare two table structures?

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:6h6g825haikbiv5r72mgujo7hvnaiat71b_at_4ax.com...
: On 8 Jun 2006 02:54:07 -0700, "Vijay" <avbhaskarreddy_at_gmail.com>
: wrote:
:
: >Hi,
: >
: >Is there any option in TOAD/SQL Navigator to compare two table
: >structrues(weather two are having same structure or not).
: >
: >Thanks!
: >Vijay
:
:
: The commercial version of Toad has a compare schema tool.
:
: Depending on version you could also dbms_meta_data and/or
: dbms_rectifier_diff
:
: --
: Sybrand Bakker, Senior Oracle DBA

IIUC, dbms_rectifier_diff isn't much help since it's designed for use with replication ...

if the structures differ, all you get is an exception ORA-23370: table TESTTBL2 and table TESTTBL are not shape equivalent (number of columns differ)

additionally if the structures are the same, differences in row values are only identified by the site (identical in this case), not by the tablename or schema

i don't see any provision for analyzing structure differences with dbms_meta_data -- it just reports the structures

am i missing something?

++ mcs Received on Thu Jun 08 2006 - 08:52:11 CDT