How to Drop invalid synonyms [message #305569] |
Tue, 11 March 2008 05:15  |
manns
Messages: 59 Registered: March 2006 Location: Bangalore
|
Member |

|
|
One of my Scheem there are some invalid synonyms named like
SYNONYM /8777232d_CSVWS_ALL_CONTRACT_E..
select * from user_objects where object_name='/8777232d_CSVWS_ALL_CONTRACT_E'
/8777232d_CSVWS_ALL_CONTRACT_E 4328800 SYNONYM 2/7/2008 11:42:42 AM 2/7/2008 11:42:42 AM 2008-02-07:11:42:42 INVALID N N N
I wanted to drop this synonyms but the result is as follow..
SQL> drop SYNONYM /8777232d_CSVWS_ALL_CONTRACT_E
2 /
drop SYNONYM /8777232d_CSVWS_ALL_CONTRACT_E
*
ERROR at line 1:
ORA-00995: missing or invalid synonym identifier
Pls help me to drop this invalid synonyms
thanks
Manju
|
|
|
|