Upgrade 8.0.5 to 8.1.6

From: Ed <mrclark_at_xnet.com>
Date: Tue, 20 Nov 2001 15:29:57 -0800
Message-ID: <F001.003CA189.20011120150022@fatcity.com>

A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6 by using export/import. This will probably work, but wouldn't it be easier to just do a cold backup and open them using the COMPATIBLE parameter in the 8.1.6 environment? Is there any downside to using export/import? (ie. will it affect snapshots, db links, etc...).

I thought the whole point of the compatible parameter was that it let you open up an older database with no questions asked. Then you could run any of the upgrade .sql scripts at your leisure, yes?

Best,

--

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

Author: Ed
INET: mrclark_at_xnet.com

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: 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 Tue Nov 20 2001 - 17:29:57 CST