Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback Segments

Re: Rollback Segments

From: Eike J. Heinze <eike_heinze_at_compuware.com>
Date: Tue, 13 Apr 1999 15:13:53 -0500
Message-ID: <3713A580.B10798BE@compuware.com>


Hi;
having no idea of what version you are running it's a kind of risky. But you could set AUTOEXTEND ON for the files involved IF YOU ARE SURE you don't fill up your file system and if maxextents is unlimited. BUT I warn to do that, it's not the clean thing. Rollback should be sized diligently. Ever had a "runaway" procedure inserting unlimited numbers of rows? ;-((
Regards Eike

dcard2_at_maine.rr.com wrote:

> Is there a way to make rollback segments/tablespaces grow automatically?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Apr 13 1999 - 15:13:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US