Help: Can't remove rollback segment

From: Andre M. J. <andreas_at_xmission.com>
Date: Tue, 23 Feb 1999 06:51:25 -0700
Message-ID: <36D2B25D.F484BC9E@xmission.com>

Hi,
I can't remove corrupted rollback segment (WGS 8.0.3.0.0 on NT 4.0 SP3).

Somebody was using large (1GB) rollback segment by deleting rows from a huge table and cross size of the rollback segment. The rollback segment has status "Need Recovery". I did try recover - didn't help. I can't drop the rollback segment, or the table space where it exist. I did create a other table space with new rollback segment and put everything off-line i the other where exist the corrupted rollback segment.

What to do???

Thanks in advance,
AMJ Received on Tue Feb 23 1999 - 07:51:25 CST