ORA-12838: cannot read/modify an object after modifying it in parallel

Got an email from user complaining some issue about his query..

 
We are facing an issue while inserting data with below query:
INSERT /*+ append */ INTO MEMBER_CORE_LINK
SELECT /*+ parallel(8) */ * FROM MEMBER_CORE_LINK_KK
MINUS 
select /*+ parallel(8) */ * from member_core_link


below is his error

 
I am not able to Fire any query or do the inserts I want to do from above query.

Error:-
ORA-12838: cannot read/modify an object after modifying it in parallel
12838. 00000 -  "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.

i replied to the user….

 
Hi Prod user,

Can you do a commit after you insert in MEMBER_CORE_LINK
After the commit you can perform the select.

Thanks!

his reply

 
Hi Ronnie,

Once committed I am able to work on this table. Thanks.

Thanks & Regards,
prod user

Thanks!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s