Home » RDBMS Server » Server Utilities » Re: SQLPlus related
Re: SQLPlus related [message #368057] Tue, 08 February 2000 05:24 Go to next message
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 Go to previous message
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
Previous Topic: Re: Sqlloader Reference Guide?
Next Topic: Re: Problem with importing Views
Goto Forum:
  


Current Time: Mon May 23 22:10:44 CDT 2022