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

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

From: John Dorlon <[email protected]>
To: "<[email protected]>" <[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]> wrote:


  
>Thanks John for quick feedback.  I couldn't find the Generate Schema Script window.  
>
>
>
>From: John Dorlon <[email protected]>
>To: "[email protected]" <[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]] On Behalf Of Lisa Hu
>Sent: Monday, July 16, 2012 4:52 PM
>To: [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  
>
>