drop synonym

[steeve123]

OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME
------------------------------ ------------------------------ ------------------------------ ------------------------------
PUBLIC javax/mail/search/HeaderTerm DEMO40 javax/mail/search/HeaderTerm

I have weird public synonym that i want to drop.
but i cant:


SQL> drop public synonym javax/mail/search/HeaderTerm;
drop public synonym javax/mail/search/HeaderTerm
*
ERROR at line 1:
ORA-00933: SQL command not properly ended


How to drop that synonym?

[adewri]

[email protected]D> create table "test/testing/new" (x integer);

Table created.

[email protected]D> create public synonym "test/testing/new" for "test/testing/new";

Synonym created.

[email protected]D> desc "test/testing/new"
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------------------------------
 X                                                              NUMBER(38)

[email protected]D> desc test/testing/new
SP2-0565: Illegal identifier.
[email protected]D> drop public synonym test/testing/new;
drop public synonym test/testing/new
                        *
ERROR at line 1:
ORA-00933: SQL command not properly ended


[email protected]> drop public synonym "test/testing/new";

Synonym dropped.

[email protected]D>