Hello
we have a problem with a database:
The database cannot start up and we get:

ORA-00604: error occurred at recursive SQL level 1
ORA-01552: cannot use system rollback segment for non-system tablespace
'INDEX'

Is there any chance to create new rollback segment when the database is
mounted only? Or is it possible to make rollback segment online in this
mode? Why the database tries to access this tablespace during startup? How
can I check if there is a startup trigger?
We have rollback segments listed in init.ora file.
Thank you for quick responce, unfortunatelly I dont have access to metalink
now.
Ivo Libal


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Libal, Ivo
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to