Hi Achille,
There is an undocumented intialisation parameter
_corrupted_rollback_segments (or segments may be abbreviated to segs, it's
that long since I used it that I can't remember the precise name). If you
set this to a comma separated list of the names of the rollback segments in
the rollback tablespace to be dropped and the mount your database you may
then be able to drop and recreate your rollback tablespace. Obviously the
active transaction still can't be rolled back, so what the state of the
table(s) involved will be is open to question.
Regards,
Rob
--
Posted from rly-ip01.mx.aol.com [205.188.156.49]
via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Mon Feb 19 2001 - 12:05:23 CST
