Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: cannot drop the procedure

Re: cannot drop the procedure

From: P. van der Ven <pven_at_iname.com>
Date: Sat, 18 Dec 1999 17:42:08 GMT
Message-ID: <385bc756.259824978@news.giganews.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?

Have you already tried to restart the db?

>Thanks a lot.
>
>WangYang.

Regards,
P. van der Ven
---
http://contactpven.da.ru/ Received on Sat Dec 18 1999 - 11:42:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US