Re: Error occured when I wanna drop any view or index

fish wrote:

> 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

Post the SQL statement you are trying to execute.

Daniel Morgan Received on Tue Aug 06 2002 - 16:22:12 CDT