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!
Hi Ronnie, Once committed I am able to work on this table. Thanks. Thanks & Regards, prod user