Note the space between the "." and the first letter of the synonym's name.
SQL> drop synonym xlink. ps_sl_projectsu_vw;
Synonym dropped.
SQL> c/. p/.p
1* drop synonym xlink.ps_sl_projectsu_vw
SQL> /
drop synonym xlink.ps_sl_projectsu_vw
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist
One learns something new every day.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
