Hi: You can try the ocidiff utility, http://www.dbatools.net/mytools/table_struct_compare_repair.html On Fri, Nov 7, 2008 at 7:55 AM, Mary Elizabeth McNeely < mary_mcneely@xxxxxxxxx> wrote: > Good afternoon, all, > > I seek your opinions/experiences about tools that can compare two Oracle > schemas (or the same schema on two databases) and make a report of the > differences. Ideally, it would also create the SQL needed to resolve those > differences: create indexes (or indices, if you will), add columns, recreate > views, etc. > > I know TOAD has such a tool, but it's proven ineffective for us, as it > generates many false positives, especially when one schema is an imported > copy of the other - that makes for subtle capitalization/double > quote differences in stored SQL, plus other troubles. Physical clones don't > have these differences, but we mainly want to compare imported schemas for > divergence from their parent schemas. > > Thanks in advance for whatever advice you have to offer. > > Kind regards, > Mary Elizabeth McNeely > Purveyor of Trouble > -- > //www.freelists.org/webpage/oracle-l > > > -- Welcome! http://www.AnySQL.net/en