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?
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.
