RE: Help Huge Database Restore using exp/imp !!!! Help Please !!!

I'm also curious about the questions Mark raised, but if the assumption is that exp/imp is your only option, then I think your plan looks good. I would just add that you might want to set commit=y on your import to avoid running out of rollback space and also set buffer=10485760 to speed things up a bit. Don't forget to set your indexes back to noparallel after you're done rebuilding them. Also, I'm not sure what you mean about the stored procedures, packages and views - why/how would you do them separately? Wouldn't they just get imported along with the tables and data in the first import?  

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of BN Sent: Thursday, March 16, 2006 5:12 PM
To: Oracle-L Freelists
Subject: Help Huge Database Restore using exp/imp !!!! Help Please !!!

Greetings,  

Oracle 9.2.0.6 on HP-UX 11.11, 12 CPU
Database Size: 600 GB
Reason: Database Corruption
Action Plan: Oracle Recommended to go for exp/imp because of Data dictionary Corruption

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 16 2006 - 22:57:12 CST