RE: Oracle8i to 10g upgrade using exp and imp

  • From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • To: "oraclelist@xxxxxxxxxxxxx" <oraclelist@xxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 25 Jun 2009 14:28:33 -0700

In regards to the barrage of errors with a full exp/imp, I just use grep to 
quickly filter out all the errors I don't care about and check for anything 
important, so that's not really a problem as long as you're familiar with grep 
or similar filtering commands.

Yes, you can speed things up by breaking up the exp/imp into multiple 
concurrent streams, so that's definitely a consideration if you're under tight 
time constraints, but then again if that's an issue, you may need to use dbua 
instead or some other method to minimize downtime.

I've never had any problems with "version specific junk" getting imported, so 
without more detail I wouldn't worry too much about that.

There's no "right" answer here - as usual, it depends.  I think it all just 
comes down to testing to find out what works best for you in your specific 
situation, but I definitely would not rule out full=y without consideration.  
I've used it for 20+ upgrades with no problems, and it's even supported by 
Oracle.

Regards,
Brandon

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Randy Johnson


I've done several upgrades using export/import and I wouldn't recommend doing a 
full database export . . .


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

Other related posts: