Re: upgrade or install?

You can not upgrade from 8.0.5 to 9i. See note 159657.1 on metalink. You need to upgrade to 8.0.6 and then to 9i.

If you can afford the down time I think that export/import directly to 9i is better then two installs and two upgrades. This is the way we plan to do it.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, May 01, 2003 11:51 PM

> IS it easy to upgrade from Oracle 8.0.5 to 9i
> or should I just do a complete install of 9i.
>
> Joe
>
> -----Original Message-----
> Sent: Thursday, May 01, 2003 2:07 PM
> To: Multiple recipients of list ORACLE-L
>
>
> It says that you are supposed to commit or rollback before doing parallel
> dml on the object.
> But you can still get the error since there is a bug in 9.2 which will be
> fixed in Oracle 10.
> we were hit by this bug and had to request a back port to come with a
patch
> for 9.2.
>
> The patch is available now for 9.2 Solaris (and probably AIX).
>
>
> Regards,
>
> Waleed
>
>
> -----Original Message-----
> Sent: Thursday, May 01, 2003 4:32 PM
> To: Multiple recipients of list ORACLE-L
>
>
> here is what it says on OTN. Not sure what it means.
>
> ORA-12838 cannot read/modify an object after modifying it in parallel
>
> Cause: Within the same transaction, an attempt was made to add read or
> modification statements on a table after it had been modified in parallel
or
> with direct load. This is not permitted.
>
> Action: Rewrite the transaction, or break it up into two transactions: one
> containing the initial modification and the second containing the parallel
> modification operation.
>
> INSERT /*+append*/INTO tab1(col1)
>
> SELECT col1
> FROM tab2
> where col2 in (select col2
> from tab2
> minus
> select to_number(col3)
> from tab1
> where col4 <> 'XX')
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <rgaffuri_at_cox.net
> INET: rgaffuri_at_cox.net
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Leyden, Joseph
> INET: LeydenJ_at_MTA.NET
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

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).