Yes it will save time as well ..all the upgrade does
is mess the datafile headers so they are 816 format
also the upgrade script will simply re-initialze the
catalog to 816 is also quite fast and will complete in
a few minutes ..
if you have a 1TB db for e.g. upgrade would definitely
be a far more faster option ..
as for upgrade breaking your db .. more chances that
your approach of only setting the compatable flag
might in turn lead to software corruption in the long
run if not immediately .. thing change with ever
release .. and when its oracle .. this REALLY change a
lot .. and hence they recommend the upgrade path ..
however if your db is small .. then maybe creating an
an 817 db and creating tablespaces and then exp-imp
way will work as well ..
Deepak
- Ed <mrclark_at_xnet.com> wrote:
> 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 <mrclark_at_xnet.com> 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: 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).
>
>
> __________________________________________________
> 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: deepakthapliyal_at_yahoo.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).
>
> --
> 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).
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: deepakthapliyal_at_yahoo.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 Wed Nov 21 2001 - 16:58:57 CST
