| Re: SQLPlus related [message #368057] |
Tue, 08 February 2000 05:24  |
Thomas
Messages: 67
Registered: September 1999
|
Member |
|
|
Hi Anita,
Your problem is the size of the Rollback Segment.
Oracle stores the DML Information in this Segment
to enable Rollback in case of an Error in the
"long transaction". You have at least 2 ways to solve it:
Put "commit" statements in your script after
somehundred statements
or
Build bigger Rollback Segments using "maxextents unlimited or bigger initial size..."
regards Thomas
|
|
|
|
| Re: SQLPlus related [message #368080 is a reply to message #368057] |
Fri, 10 March 2000 09:22  |
Kieron Smythe
Messages: 11
Registered: March 2000
|
Junior Member |
|
|
An easy way to solve this problem is to set autocommit on. That means that the Rollback segment will never be "overflown" because autocommit will commit the records before this happens.
syntax in SQL> set autocommit on
Regards,
Kieron
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
