RE: upgrade or install?

From: Leyden, Joseph <LeydenJ_at_MTA.NET>
Date: Thu, 01 May 2003 13:51:48 -0800
Message-ID: <F001.0058DBC2.20030501135148@fatcity.com>

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). Received on Thu May 01 2003 - 16:51:48 CDT