Re: How to create an outlines to another database on Toad

I'm away from my pc at the moment but I think if you do 'select * from DBA_outlines', you'll see all the what you need to put it all together.   There may also be a call to dbms_metadata you can make but I don't think there is any other way in Toad.

- John

On Jul 16, 2012, at 6:14 PM, "Lisa Hu" <[email protected]<mailto:[email protected]>> wrote:



Unfortunately, we don't have DBA Module.  Is there another way to do it?
Thanks,
Lisa

From: John Dorlon <[email protected]<mailto:[email protected]>>
To: "<[email protected]<mailto:[email protected]>>" <[email protected]<mailto:[email protected]>>
Sent: Monday, July 16, 2012 6:05 PM
Subject: Re: [toad] How to create an outlines to another database on Toad


I didn't mention it but you need the DBA module to access that window

- John

On Jul 16, 2012, at 6:04 PM, "Lisa Hu" <[email protected]<mailto:[email protected]>> wrote:


Thanks John for quick feedback.  I couldn't find the Generate Schema Script window.

From: John Dorlon <[email protected]<mailto:[email protected]>>
To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>>
Sent: Monday, July 16, 2012 5:01 PM
Subject: RE: [toad] How to create an outlines to another database on Toad


The ‘Generate Schema Script’ window has a checkbox for outlines on the ‘object types’ tab.

You can generate script from one DB and run it in the other.
From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Lisa Hu
Sent: Monday, July 16, 2012 4:52 PM
To: [email protected]<mailto:[email protected]>
Subject: [toad] How to create an outlines to another database on Toad


Dear Toad experts,
I need help on how to create an outline from one database to another in toad (not sure if it uses Plan Control in Toad).  I am running into a situation that a new SQL runs in 20 secs on Test DB, while 40 mints on Prod.  It’s same SQL but data is a little bit different.  All parameters, indexes, tables are same on both DBs.   Both are 10.2.0.5 on similar hardware.  I am trying to export a stored outline on Test , and import to Prod Db (it's a fast fix because users are waiting to migrate SQL to production DB).   I heard Toad has tools to copy execution plan from one DB to other.  Can anyone instruct me to accomplish this task?  Any help will be greatly appreciated.
Lisa