Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete rollback segment ?
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;
--
"Some days you're the pigeon, and some days you're the statue." Received on Sun Oct 24 1999 - 23:42:22 CDT