The method that you propose is exactly the method that I used to upgrade a
10G Win NT database from 7.3.4 to 8.0.5. It worked flawlessly; though as I
remember I had to use the 7.3.4 client to do the import.
I also did an upgrade from 8.0.5 to 8.1.5 on a much larger database
(couldn't export/import it) using the migration tool. Not as much joy.
After an Oracle VP got involved we finally figured out which bit hadn't
gotten set correctly but it was two months of grief.
Of course, those were buggy versions so perhaps Oracle has gotten the
migration tool all sorted out by now but I would always go with the
export/import route if the database is small enough.
Just my $.02
James Damiano
<jadam To: Multiple recipients of list ORACLE-L
@nhes.state.n <[EMAIL PROTECTED]>
h.us> cc:
Sent by: root Subject: DB Version upgrade with
CreateDB/Import "Risky"???
05/05/2002
12:23 PM
Please
respond to
ORACLE-L
Hello fellow Oracle DBAs,
I really need your opinion on this matter:
I routinely do upgrades of Oracle software and databases on all types of
systems: Compaq Unix, Netware, Linux, etc. (as do we all from time to
time).
On one Windows/NT 4 system where I am presently doing an upgrade from a
lower version of Oracle 8 to 8.1.7, I am dealing with a particular System
Administrator for the NT box who knows a little about Oracle, but that is
obviously laboring under some misconceptions.
He strongly believes that the ONLY way one should upgrade a database (once
the software has been upgraded) is to do a "migration" (presumably as
detailed in the Oracle Migration manual) and he is URGING me to do it this
way.
On small databases (i.e. less than 10G) where downtime is not an issue, the
way I have always done it and the way I intend to do it this case is:
(1) Take a full database "export" under the old version
(2) Install the Version 8.1.7 software
(3) Recreate from scratch the database under the new software
(4) Do a full database "import" to the new database.
For our systems, I as the DBA believe and have found this to be a fully
reliable, quick, and clean method and the preferable way to do it, rather
than go through the migration procedure. He on the other hand believes that
NOT doing it via the "migration" route is very "risky".
Without going into a long spiel with him about what an upgrade IS as far as
the database itself is concerned (i.e. the data dictionary objects being
brought up to the new version), and why the way I intend to do it with a
full import is perfectly acceptable to accomplish this, I'd like to just
offer this person the opinions of some of you out there in ORACLE-L List
Land where the Oracle DBA expertise is highly respected for its stature,
I.E. so he doesn't have to believe me.
In other words, I don't want to try to convince him against his
will......I'd rather have impartial competent experts give him unbiased
testimony. Thus I humbly solicit your opinion on this matter. I believe
that
my above procedure is a simple and fully reliable way of bringing the
database up to the new software level......or perhaps it is ***I*** that am
laboring under the misconception??? May I please have your take on
this.....
Much appreciate,
JDamiano
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Damiano
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas Day
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
