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_at_nnrp1.deja.com>
Date: Sun, 05 Nov 2000 01:08:05 GMT
Message-ID: <8u2btj$8m3$1_at_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 Sun Nov 05 2000 - 02:08:05 CET