Home » SQL & PL/SQL » SQL & PL/SQL » How to Drop invalid synonyms
How to Drop invalid synonyms [message #305569] Tue, 11 March 2008 05:15 Go to next message
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
Re: How to Drop invalid synonyms [message #305574 is a reply to message #305569] Tue, 11 March 2008 05:22 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Enclose your name between ".
This is NOT an expert question. Why did you post this in expert forum and newbie one?

It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Follow them including what is said about formatting.

Regards
Michel
Previous Topic: ORA-06511: PL/SQL: cursor already open
Next Topic: Error: String literal too long
Goto Forum:
  


Current Time: Sat Dec 03 01:22:17 CST 2016

Total time taken to generate the page: 0.12005 seconds