Re: cannot drop the procedure

From: Guang Ju YANG <yangg_at_club-internet.fr>
Date: Sat, 18 Dec 1999 18:27:07 +0100
Message-ID: <83gfmi$80f$1@front5m.grolier.fr>

a recovery of your database is absolutely necessary, before doning any things else.

regards.
Yang

wy_at_fudan.edu wrote in message <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 - 11:27:07 CST