Most of the time, is spent looking for check constraints.
I this test my schemas are identical and have the following objects:
The query on tables or columns take only one of two seconds. The query on constraints take about 2 minutes.
The Oracle database is running Oracle RAC 12C on two Linux virtuals.
François Guertin** | **** Technical
Support Administrator, R&D**
Your Supply Chain Matters.™ - TECSYS
Tel.: (514) 866-5800 ext.4259 | Fax:
firstname.lastname@example.org | www.tecsys.com
De : John Dorlon [mailto:email@example.com]
Envoyé : 10 avril 2015 15:06
À : firstname.lastname@example.org
Objet : RE: [Toad for Oracle - Discussion Forum] Schema compare slow
RE: Schema compare slow
Reply by John Dorlon
The statusbar at the bottom should tell you what Toad is doing as the comparison progresses. Does anything in particular stand out as taking a long time?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.