RE: Oracle8i to 10g upgrade using exp and imp

I've done several upgrades using export/import and I wouldn't recommend
doing a full database export/import because you will get so buried in error
and warning messages you don't care about that the ones you DO care about
will get lost in the output. I've found the best way to do this is to do
schema imports. Especially if it is a big database. It is a pain to recreate
the accounts and public objects like synonyms if you don't have a tool to
help you but there are several advantages to doing it this way. I've already
mentioned the biggest QA reason. Another one is probably more relevant to
big databases but you will be able to run multiple concurrent imports. This
means you can parallelize the longest part of your migration process. It
also means that by its very nature you can cleanup and restart parts of the
process rather than having to restart the whole thing. Also, if memory
serves when I tried the full database method I ended up getting some version
specific junk from the old database mixed in with my pristine 10g database.
It probably is more tedious and more work but I believe the advantages
outweigh the cost of the extra effort.

 

Just my $.02

 

                -Randy

 

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Allen, Brandon
Sent: Thursday, June 25, 2009 1:02 PM
To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx; hrishys@xxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle8i to 10g upgrade using exp and imp

 

I disagree - why not do full=y and save yourself the effort of having to do
all the individual schemas and recreate all the users, roles, privileges,
profiles, public synonyms, etc.?  You say you would "simply recreate . . .",
but it's not really so simple when you're working with large systems that
have thousands of objects and users.  I've done several upgrades from 8i to
10g using exp/imp with full=y and not had any problems.

 

To see all the objects that are included only in a FULL export, see Table
19-3 here:

 

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#s
thref2215

 

Regards,

Brandon

 

 

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mercadante, Thomas F (LABOR)

 

Why would you want to do an exp with full=Y?

 

 

  _____  

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.


__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4189 (20090625) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Other related posts: