Toad World® Forums

How to adjust threshold for Oracle Schema Compare

Hi! Using Toad for Oracle Base Version 12.1.0.22, I am comparing two Oracle 12.1 OLTP 2,000 table instances with over 1k differences. Ran Schema Compare but failed with error >1,000 changes.

Can I increase this threshold, and if so, where?

Thanks!

Look in the options tab

From: cthurstone [mailto:bounce-cthurstone@toadworld.com]

Sent: Thursday, August 25, 2016 7:06 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] How to adjust threshold for Oracle Schema Compare

How to adjust threshold for Oracle Schema Compare

Thread created by cthurstone

Hi! Using Toad for Oracle Base Version 12.1.0.22, I am comparing two Oracle 12.1 OLTP 2,000 table instances with over 1k differences. Ran Schema Compare but failed with error >1,000 changes.

Can I increase this threshold, and if so, where?

Thanks!

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

I may be blind… but did search the Options tab carefully. How is it labeled? Thanks!

:slight_smile: Options tab > Misc options tab > “stop when # of differences reaches…” at the bottom

From: cthurstone [mailto:bounce-cthurstone@toadworld.com]

Sent: Friday, August 26, 2016 10:01 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] How to adjust threshold for Oracle Schema Compare

RE: How to adjust threshold for Oracle Schema Compare

Reply by cthurstone

I may be blind… but did search the Options tab carefully. How is it labeled? Thanks!

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.