Urgent: System tablespace corruption

From: Amol <addprabha_at_my-deja.com>
Date: Sun, 24 Sep 2000 07:01:08 GMT
Message-ID: <8qk8rg$rgb$1@nnrp1.deja.com>

Oracle gurus,

I have oracle 7.3.4 and the problem I am facing is block corruption in system tablespace. I cannot restore it from any of the backups as the corruption exists in all the backups of the DB. I did verify this using the tool "dbv". Please suggest if in any way the corruption can be removed without loss of any data.

Can I use the export utility for the above problem? What would be the implication if I change the parameter DB_BLOCK_CHECKSUM to false? Will it solve this problem? Also suggest how to find which table/index is corrupt from the system datafile. This is very urgent and your suggestions will be very much appreciated.

Amol

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Sep 24 2000 - 02:01:08 CDT