Re: Command to list all rollback segments -- HELP

John N. Alegre wrote:
>
> Could someone post the command to list all rollback segments
> for a given Tablespace?
>
> I created a rollback segment and brought it online manually
> with
>
> alter rollback segment xxxx online;
>
> I did this over six months ago and did not log the name of
> the rollback segment or set initXXXora to bring it online
> automatically. Ok, now that your done laughing could
> someone please post the command to list all rollback
> segments for a given Tablespace.
>
> All comments welcome
> john
> --
> #########################################
> # John N. Alegre
> # Andante Systems
> # Javelin Technology
> #
> # remove "remove_" spam filter on reply
> #########################################

select * from dba_rollback_segs

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse