- 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.