Toad World® Forums

compare schema problem-warning message


#1

Hi,

Latest Toad beta (13.0.0.69) x64.

In automation designer, when comparing schema, I get this warning:

This warning prevents from continuing automation script.

I know that this value is needed, but could it be somehow sent to resulting part on the top and do not stop execution?

Brg

Damir


#2

We need that information to determine initial and next extent sizes for partitions in bytes, since Oracle only gives it in blocks. If you uncheck “Partitions” in the comparison, then you won’t see the message. Of course, in that case, if we have to create any missing tables in the target schema, they will be non-partitioned, even if partitioned in the source schema.

I could make an enhancement to not try to find block size if you uncheck just initial/next in the storage options, since you may not be using those params (they aren’t so important these days anyway), but I don’t like the idea of letting the comparison proceed if it can’t give you everything that you asked for.


#3

Test

From: Damir Vadas damir.vadas@gmail.com

Date: Thursday, April 26, 2018 at 6:36 AM

To: "toadoraclebeta@toadworld.com" toadoraclebeta@toadworld.com

Subject: Re: [Toad for Oracle - Beta Discussion Forum] compare schema problem-warning message

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Hi John

I know that you need this information.

But I would like to compare schemes in a way that this warning is not a dialog…prevent further execution.

I do not know how to better describe mine standing.

Brg

Damir

Brg,**
________________________**

Damir Vadas

http://damir-vadas.blogspot.com

**Life begins after the 50’s - until then it’s just a research!
**Život počinje poslije 50-te-sve do onda je samo istraživanje!

Razmislite o čuvanju okoliša prije nego odštampate ovaj e-mail

Please consider the environment before printing this email

On Thu, Apr 26, 2018 at 3:25 PM, John Dorlon <bounce-jdorlon@toadworld.com > wrote:

** RE: compare schema problem-warning message**

Reply by John Dorlon

We need that information to determine initial and next extent sizes for partitions in bytes, since Oracle only gives it in blocks. If you uncheck “Partitions” in the comparison, then you won’t see the message. Of course, in that case, if we have to create any missing tables in the target schema, they will be non-partitioned, even if partitioned in the source schema.

I could make an enhancement to not try to find block size if you uncheck just initial/next in the storage options, since you may not be using those params aren’t so important these days anyway, but I don’t like the idea of letting the comparison proceed if it can’t give you everything that you asked for.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.