Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: copy export plan from one database to another
A few options-
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Browett, Darren
Sent: Wednesday, March 03, 2004 4:45 PM
To: oracle-l_at_freelists.org
Subject: copy export plan from one database to another
Hi there,
We are in a bit of a panic right now, and I am busily searching the manuals,
But is it possible to copy the explain plan that looks good in your dev/test database to the production database and force your production database to use that explain plan ??
I will figure out what went wrong with the production plan once the panic is over.
Thanks
Darren
Darren Browett P.Eng This message was transmitted Data Administrator using 100% recycled electronsInformation and Communication Technology City of Coquitlam
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Wed Mar 03 2004 - 17:53:38 CST
-----------------------------------------------------------------