ORA-12841: Cannot Alter The Session Parallel DML State Within A Transaction - Learnomate Technologies

ANKUSH THAVALI
17 Dec, 2023
0 Comments
1 Min Read

ORA-12841: Cannot Alter The Session Parallel DML State Within A Transaction

Solution :

If we are enabling parallel DML option, after doing some transaction, then we need to issue COMMIT or ROLLBACK, before enabling DML parallel.

SQL> alter session enable parallel dml;
ERROR:
ORA-12841: Cannot alter the session parallel DML state within a transaction

SQL> commit;

Commit complete.

SQL> alter session enable parallel dml;

Session altered.