| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Mailing Lists -> Oracle-L -> Ora-1548 while dropping tablespace
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: helpdesk.hcl_at_bplmail.com 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: ListGuru_at_fatcity.com (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).Received on Fri Feb 07 2003 - 03:53:46 CST
![]() |
![]() |