Oracle DBA, How To, Error, Cause and Action

ORA-12830: Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE

ORA-12830: Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE

Cause:

After executing a parallel INSERT/UPDATE/DELETE statement, a command other than COMMIT or ROLLBACK was issued.


Action:

Execute COMMIT or ROLLBACK before issuing another SQL command.

No comments:

Post a Comment

Thanks for your comment.