Autocommit is not Committing after {N} Updates.
(Doc ID 304926.1)
Last updated on JANUARY 31, 2022
Applies to:
SQL*Plus - Version 8.1.7.4 to 10.2.0.1 [Release 8.1.7 to Oracle10g]Information in this document applies to any platform.
Symptoms
After setting autocommit within sqlplus to a number, commit is not taking place.
For Example.
SQL> set autocommit 2;
SQL> update <table> set <column> = <a value>
8 rows updated.
You would expect a commit to occur after the 2nd row was updated.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |