Problems with ORA-01578

Hi group

I have a problem with an Oracle 8.0.5.database running on SuSe Linux.

The problem is with a file belonging to the rollback segments. Due to a harddrive being full (I know.....) a block error has occurred in the file, probably due to lacking the ability to write to the datafiles.

What I get now when trying to open the database is ORA-00604 and ORA-01578.

Now, I can't remove the block error in any way, so, next move is to drop the tablespace. Can't do - the ORA-01578 apparently also prevents this from being done, at least that's what it says on the screen.

Has anybody got an idea of what to do? It will really be appreciated a lot.

Thank you in advance!

Soeren Received on Tue Apr 23 2002 - 17:32:38 CEST