Re: Rollback Segment

From: Frank Zekert <zekert_at_wmd.de>
Date: Mon, 27 Jul 1998 09:56:04 +0200
Message-ID: <6phbra$ic1$1@ns2.dokumenta.de>

Hi,
I'm afraid you've missed the point:
the extents allocated for the rollback segment are too small. So you should also change the storage parameters, for example

"alter rollback segment <RBS>

storage (INITIAL 1M NEXT 1M MINEXTENTS 10)"

Hope this will help.

Frank

Winnie Liu wrote in <6pgefd$37q_at_dfw-ixnews8.ix.netcom.com>...
>Increase the size of your rollback segment. It doesn't have space to expand
>to another extent.
>
>Try to make a huge rollback segment for this transaction only.
>
>use
>
>set transaction use rollback segment <rb name>;
>
>Hope it can help
>
>Winnie
Received on Mon Jul 27 1998 - 02:56:04 CDT