Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Delete rollback segment ?

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@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 Sun Oct 24 1999 - 23:42:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US