Toad Schema Compare

(W) 563 272-7211

© 563 299-7211

P Please consider the environment before printing this email

*** This email may contain information that is confidential. If you are not the intended recipient, please notify me immediately and delete the email and any attachments.***

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Wednesday, July 26, 2017 3:52 PM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad Schema Compare

Reply by John Dorlon

Your options are somewhat limited in 9i but for me that query runs in less than one second. There’s no reason that you should have to wait 24 hours on this query. It hasn’t changed in Toad since version 12.8, so I think if there were something really wrong with it, we would have heard about it before now.

You can try that query in the editor with various optimizer hints. If you get one that makes it go faster, you can go to Options -> Oracle -> Optimizer Hints, and add a row for DBA_CONS_COLUMNS with 9i as the Oracle version and then Toad will use whatever hint you plug in.

You might want to try Database -> Optimize -> Auto Optimize SQL. That will generate several rewrites and try them automatically. If you get lucky, one of them will just be an optimizer hint and you can plug in into Toad.

You might also want to look at your database - maybe there is a lot of memory swapping going on or something like that and you can throw some more memory at it.

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.

JohnDorlon · July 27, 2017, 8:27am

If SQL Optimizer wasn’t part of whatever Toad bundle that your company purchased, and you want to purchase, talk to your sales rep.

Or maybe it was part of your bundle and you just didn’t install it, so I think you could check that by re-running the installer.

Or, you could just manually try the optimizer hints in the editor.

bowersd · July 27, 2017, 8:42am

Can you give me a new trial liceense?

Thanks,

Dave Bowers

Sr. Database Administrator

HNI
Corporation

(W) 563 272-7211

© 563 299-7211

P Please consider the environment before printing this email

*** This email may contain information that is confidential. If you are not the intended recipient, please notify me immediately and delete the email and any attachments.***

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Thursday, July 27, 2017 10:29 AM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad Schema Compare

Reply by John Dorlon

If SQL Optimizer wasn’t part of whatever Toad bundle that your company purchased, and you want to purchase, talk to your sales rep.

Or maybe it was part of your bundle and you just didn’t install it, so I think you could check that by re-running the installer.

Or, you could just manually try the optimizer hints in the editor.

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.

bowersd · July 27, 2017, 8:43am

I have a trial version of 8.0.0.1551

Thanks,

Dave Bowers

Sr. Database Administrator

HNI
Corporation

(W) 563 272-7211

© 563 299-7211

P Please consider the environment before printing this email

*** This email may contain information that is confidential. If you are not the intended recipient, please notify me immediately and delete the email and any attachments.***

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Thursday, July 27, 2017 10:29 AM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad Schema Compare

Reply by John Dorlon

If SQL Optimizer wasn’t part of whatever Toad bundle that your company purchased, and you want to purchase, talk to your sales rep.

Or maybe it was part of your bundle and you just didn’t install it, so I think you could check that by re-running the installer.

Or, you could just manually try the optimizer hints in the editor.

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.

JohnDorlon · July 27, 2017, 8:44am

I’m not authorized to give out trial keys, you’ll have to talk to your sales rep for that.

bowersd · July 27, 2017, 8:56am

OK.

Under Automation Designer when I create an app, where do the execution files live and who do they belong to?

I have created an action named qa_prod_compare . Where is that script stored? Who is the owner?

Thanks,

Dave Bowers

Sr. Database Administrator

HNI
Corporation

(W) 563 272-7211

© 563 299-7211

P Please consider the environment before printing this email

*** This email may contain information that is confidential. If you are not the intended recipient, please notify me immediately and delete the email and any attachments.***

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Thursday, July 27, 2017 10:46 AM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad Schema Compare

Reply by John Dorlon

I’m not authorized to give out trial keys, you’ll have to talk to your sales rep for that.

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.

JohnDorlon · July 27, 2017, 9:02am

Well, it’s not really a script, but all actions are stored in ToadActions.dat, which is in your user files folder. This file is not meant for end-users though. If your action produces output (such as a sync script), those files will be created wherever you configured them to go in the action.

If you want to get one particular action out of ToadActions,dat, you can just copy/paste the action from Automation Designer, and paste into another copy of Toad, or another folder in the automation designer. It is text, so you could also paste into notepad or an email.

bowersd · July 27, 2017, 9:12am

And if I need for multiple users to be able to read that file?

Thanks,

Dave Bowers

Sr. Database Administrator

HNI
Corporation

(W) 563 272-7211

© 563 299-7211

P Please consider the environment before printing this email

*** This email may contain information that is confidential. If you are not the intended recipient, please notify me immediately and delete the email and any attachments.***

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Thursday, July 27, 2017 11:03 AM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad Schema Compare

Reply by John Dorlon

Well, it’s not really a script, but all actions are stored in ToadActions.dat, which is in your user files folder. This file is not meant for end-users though. If your action produces output (such as a sync script), those files will be created wherever you configured them to go in the action.

If you want to get one particular action out of ToadActions,dat, you can just copy/paste the action from Automation Designer, and paste into another copy of Toad, or another folder in the automation designer. It is text, so you could also paste into notepad or an email.

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.

JohnDorlon · July 27, 2017, 9:15am

You can export actions for them to import, but everyone has their own copy of that file.

bowersd · July 27, 2017, 9:15am

I hate to add to the confusion but there is more to this sorry tale.

When I log into TOAD using the credential of one of the users for the compare and then go to the Automation Designer then select the app (In this case App1, the default) and then do a “Run From Here” on the first of the 6 jobs I have created, they will all work flawlessly.

I then right click on each of the 6 jobs and select and complete the “Schedule” option, which generates a scheduled job for execution just as I requested.

When I then go to the Task Scheduler and try and execute the jobs that I just scheduled, they fail. This is the part that is driving me crazy.

Thanks,

Dave Bowers

Sr. Database Administrator

HNI
Corporation

(W) 563 272-7211

© 563 299-7211

P Please consider the environment before printing this email

*** This email may contain information that is confidential. If you are not the intended recipient, please notify me immediately and delete the email and any attachments.***

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Thursday, July 27, 2017 10:46 AM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad Schema Compare

Reply by John Dorlon

I’m not authorized to give out trial keys, you’ll have to talk to your sales rep for that.

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.

JohnDorlon · July 27, 2017, 9:20am

Fail how? Is there an error message?

bowersd · July 27, 2017, 10:14am

That is the problem. There is nothing

Thanks,

Dave Bowers

Sr. Database Administrator

HNI
Corporation

(W) 563 272-7211

P Please consider the environment before printing this email

*** This email may contain information that is confidential. If you are not the intended recipient, please notify me immediately and delete the email and any attachments.***

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Thursday, July 27, 2017 11:21 AM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad Schema Compare

Reply by John Dorlon

Fail how? Is there an error message?

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.

jbowman · July 27, 2017, 12:01pm

Hi Dave,

You may need to click the refresh button in the task bar within the Task Scheduler window in order to update the list. I don’t believe that screen automatically refreshes, but it should show you the results of the last execution under the “Last Run Result” column. Or, are you executing it from Window’s Task Scheduler (Start -> All Programs -> Accessories -> System Tools -> Task Scheduler)?

-John

JohnDorlon · July 27, 2017, 12:12pm

Some people have had trouble sending email from a scheduled action, maybe that’s it? If you have email output configured, try disabling it (if you don’t know if you enabled it, you probably didn’t - doesn’t apply to all types of comparison).

bowersd · July 27, 2017, 1:00pm

As much as it embarrasses me, we seem to have discovered the source of the problem.

Since I developed this process about 10 years ago, it didn’t seem to matter what user “owned” the TOAD processes and what user ran the scheduled jobs. We assigned a group use id so that if my password changed and I owned the scheduled jobs, they would of course fail.

At the beginning of this year we introduced a new method of assigning user id and have changed everyone over to an AD user id. It was of course different than the previous user id. So when I used my AD account within TOAD, everything work just fine, but evidently it caused great problems.

So today I moved the ToadActions.dat file to the correct location under the group user and then logged into TOAD using that user. Of course the jobs worked correctly. The real test was: Would it now work as a scheduled job. I reenabled the jobs and ran them one at a time and they all worked correctly. They will run again at their scheduled times tomorrow morning. I will check them then to ensure that the did in fact work correctly.

If they do work correctly, we can close this thread.

Thanks for all your assistance.

Thanks,

Dave Bowers

Sr. Database Administrator

HNI
Corporation

(W) 563 272-7211

P Please consider the environment before printing this email

*** This email may contain information that is confidential. If you are not the intended recipient, please notify me immediately and delete the email and any attachments.***

From: John Bowman [mailto:bounce-jbowman@toadworld.com]

Sent: Thursday, July 27, 2017 2:03 PM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad Schema Compare