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
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.
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:
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.
