copy export plan from one database to another

From: Browett, Darren <dbrowett_at_coquitlam.ca>
Date: Wed, 3 Mar 2004 15:45:03 -0800
Message-ID: <8423DAC11EF82D469CF20CE341CC4EDF02C924AD@EXCHANGE.private.coquitlam.bc.ca>

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 electrons
Information and Communication Technology City of Coquitlam
P:(604)927 - 3614
E:dbrowett_at_coquitlam.ca

---

---

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Wed Mar 03 2004 - 17:45:46 CST