Re: Rollbacks online

> ok. silly question. how do you make sure your rollbacks are online when the
> database comes up. I thought you specified this in init.ora, but that didn't
> work.

You bring them up in the init.ora

rollback_segments = (rbs01, rbs02, rbs03, rbs04)

As for verifying they are up, log in and check.

select segment_name, status from dba_rollback_segs;

I don't know if this answered your exact question, but I hope it helped!

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Joe Frohne, OCP
Database Administrator
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Received on Thu Jun 01 2000 - 13:21:00 CDT