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