Topic
1 reply Latest Post - ‏2010-01-08T00:13:45Z by Ivan_CA
larsbh
larsbh
1 Post
ACCEPTED ANSWER

Pinned topic Ability to turn off autocommit

‏2010-01-07T22:32:14Z |
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
    Ivan_CA
    2 Posts
    ACCEPTED ANSWER

    Re: Ability to turn off autocommit

    ‏2010-01-08T00:13:45Z  in response to larsbh
    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.

    Thanks,
    Ivan