Re: DATABASE COMPARE SCRIPT

[Bunyamin K. Karadeniz]

Title: RE: When to go for ORACLE NAMES Server

****************************************************************   -- DATATYPE.sql -- -- To check datatype consistency between two environments -- --   SELECT table_name, column_name, data_type, data_length, data_precision, data_scale, nullable FROM all_tab_columns -- first environment WHERE owner = '&OWNER' MINUS SELECT table_name, column_name, data_type, data_length, data_precision, data_scale, nullable FROM all_tab_columns@&my_db_link -- second environment WHERE owner = '&OWNER2' order by table_name, column_name; ----- Original Message ----- From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Saturday, May 12, 2001 12:20 AM Subject: DATABASE COMPARE SCRIPT I am trying to find out the schema differences between two databases.  Differences like Column size,column datatype,column data length, indexes,tables,constraints etc. If anyone has a script or know where I can get one that will accomplish this, please let me know. Thank you.