Re: cannot drop the procedure

From: Andre Whittick Nasser <awnasser_at_openlink.com.br>
Date: Sat, 18 Dec 1999 16:21:03 -0200
Message-ID: <83giuq028n9@enews2.newsguy.com>

Probably, the datafile corresponding to the system tablespace is corrupted. This tablespace stores the data dictionary and consequently the procedure code.

In fact, there may be some kind of media problem. First run some kind diagnostics on the disk (fsck on UNIX, disk doctor on Windows) to determine if the disk is bad. If so, you will have to replace it with another disk and then apply the recovery procedures.

Regards,

André Whittick Nasser

wy_at_fudan.edu escreveu na mensagem <83g0t8$fol$1_at_nnrp1.deja.com>...
>SQL> drop procedure pro_jxc1999;
>drop procedure pro_jxc1999
>*
>ERROR at line 1:
>ORA-00604: error occurred at recursive SQL level 1
>ORA-01578: ORACLE data block corrupted (file # 1, block # 67810)
>ORA-01110: data file 1: '/disk1/oradata/ora8/system01.dbf'
>
>
>how can I do with it?
>
>Thanks a lot.
>
>WangYang.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sat Dec 18 1999 - 12:21:03 CST