Oracle Error ORA-39822: A new direct path operation is not allowed in the current transaction.

Oracle Error Message

ORA-39822: A new direct path operation is not allowed in the current transaction.

Reason for the Error

All previous direct path contexts ended and the current transaction was ready for a commit or abort of those changes.

Solution

Commit or abort the current transaction, and start a new transaction for the next direct path context.