Re: Delete rollback segment ?
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 25 Oct 1999 12:42:22 +0800
Message-ID: <3813DFAE.4D1_at_yahoo.com>
Date: Mon, 25 Oct 1999 12:42:22 +0800
Message-ID: <3813DFAE.4D1_at_yahoo.com>
Iks wrote:
>
> Hi,
>
> I added new disks to my machine. Now I would like to rebuild tablespaces.
> I don't know how to remove my rollback segment I created previously.
> I there anybody who can help me ?
>
> Grzegorz
alter rollback segment xxx offline;
drop rollback segment xxx;
-- =========================================== Connor McDonald "These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com "Some days you're the pigeon, and some days you're the statue."Received on Mon Oct 25 1999 - 06:42:22 CEST