Ed: If you track down the 8i migration manual, here's a comparison chart that shows the benefits of export/import versus migration (using the uxxxx scripts).
It depends on your database configuration, but yes, the main benefit in using migration is speed. If your database is relatively small, exp/imp should be no problem. If it's large, the difference betwen exp/imp and migration will be significant. HTH. Barb >From: "Ed" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Upgrade 8.0.5 to 8.1.6 >Date: Wed, 21 Nov 2001 13:15:20 -0800 > >Yes, I agree 100%, but people here are concerned that upgrading will >"break" >the database, and we have to QUICKLY move everything over to 8.1.6. (Long >story). What I was really after in my original question was: why is the >upgrade script a better solution than just recreating the tablespaces in >8.1.6 and importing from an export of the old database? Does it just save >time? Is there a downside to using export/import this way? > >Best! > >Ed > >-----Original Message----- >Thapliyal >Sent: Wednesday, November 21, 2001 12:20 PM >To: Multiple recipients of list ORACLE-L > > >Ed, > >the whole point of compatable is to mimick behaviour >of an older release .. like optimizer plans etc. >upgrading the db would be the way to go for this.. >like many have already pointed out > >Deepak > >--- Ed <[EMAIL PROTECTED]> wrote: > > 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, > > > > Ed > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Ed > > 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). > > >__________________________________________________ >Do You Yahoo!? >Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. >http://geocities.yahoo.com/ps/info1 >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Deepak Thapliyal > 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: Ed > 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). _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barbara Baker 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).