Re: Help! failed to extend rollback segment error.

From: David Ng <David_Ng_at_mindlink.bc.ca>
Date: 1995/11/28
Message-ID: <49efai$rpf_at_fountain.mindlink.net>#1/1

Hi,

Try set the optimal size of the rollback segment. (That make the rollback segment will shrink back to a pre-defined size). SQL statement will be like

Alter table A default storage(initial 500K next 500K optimal 1M)

>
>
> Hi ,
>
> My rollback segments are keep growing, is there a way to cleanup the
> rollback segments savely?
>
> Thanks!.
>
>
Received on Tue Nov 28 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Todd Luton: "Re: Oracle hits new low (for me) in telephone support"
Previous message: Snufupagus: "Re: optimizing join query statement"
Maybe in reply to: Stancu Victor: "Help! failed to extend rollback segment error."
Next in thread: Todd Luton: "Re: Oracle hits new low (for me) in telephone support"
Reply: Rene Hoekstra: "Re: Help! failed to extend rollback segment error."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message