#commit transaction

ORA-12841: Cannot alter the session parallel DML state within a transaction

ORA-12841: Cannot alter the session parallel DML state within a transaction

Error ORA-12841: Cannot alter the session parallel DML state within a transaction

Cause Cause Transaction in progress. Example of cause: Try to enable the Parallel DML operation with alter command after starting the transaction. SQL> insert /*+ parallel (test10) */ into test10 select * from dba_objects; 72983 rows created.