Oracle-L: RE: Db. Upgrade Assistant

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 02 Apr 2003 07:48:36 -0800
Message-ID: <F001.005780B6.20030402074836@fatcity.com>

Vladimir - Since I don't see a reply posted to your question, I'll make an attempt. I haven't had much direct experience with this tool, but like any tool it may cause problems under some circumstances. I think Oracle has laudable goals for giving everything a GUI interface to please those who don't think you can operate a computer without a mouse. My assumption is that underneath it is running the same scripts you can run manually. Here are my issues:

For small production databases, I usually want to create a fresh database and export/import the data. That way I get a totally "9i" database with no concern for compromises. I get an opportunity to reorganize everything.
For really large production databases, I wouldn't trust a GUI tool. I have had experience where there was an error but the GUI somehow didn't report it. I want to run the upgrade scripts first on a test database, then repeat the exact steps on production.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>

-----Original Message-----
Sent: Wednesday, April 02, 2003 4:59 AM
To: Multiple recipients of list ORACLE-L

I'm about to upgrade 8.1.7 db to 9.2 db.

Platform is AIX.

"Database Upgrade Assistant" is going to be used. Does anyone have any bad experience with this oracle tool? Or the whole process is straight forward?

Thanks,
Vladimir Barac

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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). Received on Wed Apr 02 2003 - 09:48:36 CST

RE: Db. Upgrade Assistant - any bad stories?