Oracle-L: RE: ORA-12838 when trying to do insert append?

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Thu, 01 May 2003 13:06:39 -0800
Message-ID: <F001.0058DB89.20030501130639@fatcity.com>

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