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

Question

OracleDba · Accepted Answer

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.

Solutions(1)