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

From: Seefelt, Beth <Beth.Seefelt_at_TetleyUSA.com>
Date: Thu, 01 May 2003 13:41:41 -0800
Message-ID: <F001.0058DBA6.20030501134141@fatcity.com>

It wants you to commit after the insert.

-----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: Seefelt, Beth
INET: Beth.Seefelt_at_TetleyUSA.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------