Re: Rollback segment status invalid

Hi,

You can try in this way:

1. in the init.ora file insert the hidden parameter _offline_rollback_segments=(rollbacks with INVALID status)
2. startup the istance
3. alter rollback segment ..offline
4. drop rollback segment .....

good luck

Mattias Johnsson wrote:

> Hello,
>
> We are running Oracle 716 on sun/solaris 2.5.
>
> I have a rollback segment that has status
>
> invalid. I can't drop it (reports not found)
>
> or disable it (same).
>
> Any ideas? Will it stop me from dropping the
>
> tablespace?
>
> Thanks
>
> Matt
>
> -**** Posted from Supernews, Discussions Start Here(tm) ****-
> http://www.supernews.com/ - Host to the the World's Discussions & Usenet
Received on Tue Dec 01 1998 - 06:09:14 CST