When I did this, the migration assistant was much quicker than export/import.
Kent >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). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kent Wayson 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).
