Datablock Corruption

From: Gordy <gdsell_at_my-deja.com>
Date: 2000/07/03
Message-ID: <8jorvb$l02$1@nnrp1.deja.com>#1/1

Hi there,

I have just run the following command with the following results.

ANALYZE TABLE LBBKSEC ESTIMATE STATISTICS *
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 1, block # 81058) ORA-01110: data file 1: 'D:\ORANT\DATABASE\SYS1STN3.ORA'

Does anybody have a script to find out if any more corruption exists and does anyone have a recommended course of action apart from last nights backup....?

Cheers
Gordon

--
Gordy
ICQ 3290116
http://www.geocities.com/Area51/Cavern/4253


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Mon Jul 03 2000 - 00:00:00 CDT