Hi all,
I have the following
problem.
One datafile was
accidently
dropped from the
tablespace
RBS, when the database
was in
Restricted Mode.When
trying
to recover i was not able
to
neither drop the rollback
segment nor tablespace. i
am
getting the following
error.
when i do a "drop
rollback
segment RBS01"
i get the error
"ORA-01545: rollback
segment
'RBS01' specified not
available"
When i do a
"drop tablespace RBS
including contents"
i get the error
"ORA-01548: active
rollback
segment 'RBS01' found,
terminate dropping
tablespace"
when i query
dba_rollback_segements i
see
that the status of the
rollback
segment is in "NEEDS
RECOVERY
"
I set the event (10015)
in
the init file to find out
the
active transaction in the
rollback. But no object
id
was found in the trace
file.
Is there any way to
recover/drop the
tablespace
other than using _
parameter
?
TiA
Priya
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
