Search This Blog

Total Pageviews

Tuesday, 6 June 2023

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

 

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


INSERT /*+ APPEND */ INTO spm_test_tab
SELECT level,
       'Description for ' || level
FROM   dual
CONNECT BY level <= 10000;




SELECT description
FROM   spm_test_tab
WHERE  id = 99;
FROM   spm_test_tab
       *
ERROR at line 2:
ORA-12838: cannot read/modify an object after modifying it in parallel


==============================================================================================
Commit statement will fixed the error ORA-12838
==============================================================================================

SQL> select count(*) from spm_test_tab ;
select count(*) from spm_test_tab
       *
ERROR at line 1:
ORA-12838: cannot read/modify an object after modifying it in parallel


SQL> commit ;  <<<<<  !!!!! commit ...

Commit complete.



now working !!!!

SQL> select count(*) from spm_test_tab;

  COUNT(*)
----------
     10000



No comments:

Oracle DBA

anuj blog Archive