Pinned topic Ability to turn off autocommit
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
I'm looking to switch from Quest/Toad to Optim Database Administrator and have been unable to locate where I might be able to turn off autocommit. When running scripts with multiple statements, it is often critical to ensure that all or none are committed - is that possible?
Updated on 2010-01-08T00:13:45Z at 2010-01-08T00:13:45Z by Ivan_CA
Ivan_CA 270002NHNH2 Posts
Re: Ability to turn off autocommit2010-01-08T00:13:45ZThis is the accepted answer. This is the accepted answer.Hi,
It is possible to manage multiple statements when you use Change Management scripts. ODA allows you to do partial undos, full undos or restarts of your scripts.
Please take a look at the "Working with change management scripts" section in the doc and if you still have issues let us know.