SOLVED

ORA-12839: Cannot Modify An Object In Parallel After Modifying It

Asked by OracleDba13 viewsoracle

ORA-12839: Cannot Modify An Object In Parallel After Modifying It

#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
We need to issue, COMMIT or ROLLBACK, before running that parallel DML query.

SQL> delete /*+ parallel (test) */ from test;

delete /*+ parallel (test) */ from test

*

ERROR at line 1:

ORA-12839: cannot modify an object in parallel after modifying it

SQL> commit;

Commit complete.

SQL> delete /*+ parallel (test) */ from test;

1319795 rows deleted.

Hope it Helps!
OracleDba

Post Your Solution