Re: Dropping Public Synonym

If the synonym does not belong to you and you DROP ANY SYNONYM, then you should prefix the SYNONYM with the schema name. for example:
DROP SYNONYM SCOTT.synonym_name

Ashish Parekh wrote in message <37B1B506.26DF26C0_at_earthlink.net>...
>Hello ,
>
>I have a problem dropping a public synonym. I have "DROP ANY SYNONYM" ,
>"DROP PUBLIC SYNONYM" priveleges and CREATE provielges for creating
>public synonym.
>
>I get the following error message when I attempt to drop the public
>synonym.
>
> ORA-00604 - error occured at recursive SQL level 1
> ORA-00942 - table or view does not exist.
>
>Also, the table exist in the database. We are using Oracle 8.0.4 on
>Windows NT
>I get the same message in Oracle Schema Manager and SQL Plus.
>
>I am new to Oracle.
>
>Any help to resolve this problem will be highly appreciated.
>
>You can directly contact me at my email address.
>
>Thanks in advance for your time and effort.
>
>Ashish Parekh,
>Oxnard, California, USA.
>Email : asparekh_at_earthlink.net
>
>
>
Received on Thu Aug 12 1999 - 06:12:48 CEST