Re: Problems with corrupted data blocks

Hi Paul,

It sounds like you have got a data block corruption in one of the PL/SQL base tables, that stores either the source code or the compiled code. Check the segment name with the following query;

select *
from dba_segments
where file_id = 1
  and 10088 between block_id and block_id + blocks - 1;

I would suggest running a DB Verify against the SYSTEM tablespace, and if this reports the block corruption, then to confirm the block corruption perform a user level export of the SYS account. If this still reports an error then consider recreating the database at the earliest possible time, it sounds like you have a problem on the SYSTEM tablespace.

Sorry for the bad news,
Andrew

Paul Davies wrote:

> I'm trying to create a procedure and am getting this errors:
>
> CREATE OR REPLACE PACKAGE calcSum AS
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01578: ORACLE data block corrupted (file # 1, block # 10088)
> ORA-01110: data file 1:
> '/root/devel/oracle/database/datafiles/system1.dbf'
>
> Can someone please tell me what to do about this. Other procedures are
> created just fine.
>
> Thanks
>
> Paul
Received on Mon May 24 1999 - 09:04:13 CDT