Home » RDBMS Server » Server Utilities » Re: SQLPlus related
Re: SQLPlus related [message #368057] Tue, 08 February 2000 05:24 Go to next message
Messages: 67
Registered: September 1999
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
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


Previous Topic: Re: Sqlloader Reference Guide?
Next Topic: Re: Problem with importing Views
Goto Forum:

Current Time: Mon Feb 26 15:56:33 CST 2024