Error occured when I wanna drop any view or index

From: fish <zuohong.f.yu_at_bigfoot.com>
Date: Tue, 6 Aug 2002 09:56:21 +0800
Message-ID: <ainir5$h3a$1@mail.cn99.com>

Hi all,

Thesedays I'm learning SQL in my ORACLE8i+RedHat7.2 environment. I can *create* index and view as I need. But there's an error message occured when I want to *drop* any view or index:

---

SQL> drop view myview1;

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1
ORA-04052: error occurred when looking up remote object


--------------------------------------------------------------

I don't know what happened this time. Please give me some guide.

Thank you so much.

fish Received on Mon Aug 05 2002 - 20:56:21 CDT