The dba module in Toad is very good I've been using it for years. On 06/11/2008, 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 > > > -- Howard A. Latham -- //www.freelists.org/webpage/oracle-l