| Rollback segment [message #120179] |
Wed, 18 May 2005 03:32  |
riteshu
Messages: 5
Registered: May 2005
|
Junior Member |
|
|
Hi,
I have a set of update statements which are part of a transaction. When I executed them the rollback segments got filled up and a commit performed. Obviously that is not how it should work.
How do I make sure that the transaction commits only when I explicitly commit it?
Regards
Ritesh
|
|
|
|
| Re: Rollback segment [message #120181 is a reply to message #120179] |
Wed, 18 May 2005 03:54  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
before starting the transaction issue the following statement: set autocommit off;
This will set autocommit off & transaction will commit only when u explicitly commit it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
