WinSql has a compare schema tool in it that compares the schema, data, or both. http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp And to boot you get the full functionality for 30 days with the free download version. _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Aggarwal, Meenakshi Sent: Tuesday, November 29, 2005 11:43 AM To: oracle-l@xxxxxxxxxxxxx Subject: Compare Schemas Hi, Is there a preferred tool/script available to compare schemas. Thanks Meenakshi