Re: Active rollback with no sessions

kill the session using the rollback segment or shutdown the database and mount it.

Kimon Andreou wrote:

> i am trying to drop a tablespace and but i am unable to since it
> contains an
> active rollback segment. The problem is that there are no active
> sessions or
> active transactions currently running, but oracle tells me there is one
> as
> noted below:
>
> NAME XACTS STATUS
> ------------------------------------
> system 0 online
> rollbig 1 Pending offline
> r01 0 online
> r02 0 online
> r03 0 online
>
> when trying to drop the tablespace gives:
> ora-01546: tablespace contains active rollback segment 'rollbig'
>
> trying to take rollback segment offline gives:
> ora-01545: rollback segment 'rollbig' specified not available.
>
> i need to be able to take rollbig offline to drop the tablespace and
> re-create it to have a functional big rollback segment.
>
> i also added 2 more data files to the tablespace.
>
> any ideas?
>
> thanks
>
> Kimon Andreou
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jan 10 2000 - 19:13:25 CST