Re: Clear Rollback Segement

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Sun, 05 Nov 2000 01:08:05 GMT
Message-ID: <8u2btj$8m3$1@nnrp1.deja.com>

In article <3A0398BF.24D825BC_at_hket.com>, Rayfil Cheung <rayfilcheung_at_hket.com> wrote:
> How to clear a Rollback Segment or recover a corrupted Rollback
> Segment. Thank you.
>

If there are no active transactions related to this segment:

alter rollback segment rbs1 offline;
drop rollback segment rbs1;
create rollback segment rbs1 storage(....); alter rollback segment rbs1 online;
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Nov 04 2000 - 19:08:05 CST