Re: ORA-01545:rollback segment specified not available

Andrea,

Add this to your INIT.ORA file:

_offline_rollback_segments = ( <rollback name1>,<rollback name2> )

to force the rollback segment offline.

HTH Graham

--
Empowerment - delegating the responsibility but not the authority.

Opinions expressed do not necessarily reflect those of Abbott Laboratories.

andrea_johnson_at_wolfe.net wrote in message <7ga652$r4k$1_at_nnrp1.dejanews.com>...
>How can I put the tablespace including the rollback segement back online
(it's
>offline now) if I can't open the database because of the error?
>
>Startup mounts, but won't open because of the unavailable rollback segment.
>After that, alter database open results in: ORA-00704 - bootstrap process
>failure/ORA-00705 - inconsistant state during startup: shutdown the
instance,
>then restart it. (shutdown/restart doesn't help)
>
>Help?
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Apr 29 1999 - 13:44:27 CDT