Code:
sys@ACME.WORLD> create table "test/testing/new" (x integer);
Table created.
sys@ACME.WORLD> create public synonym "test/testing/new" for "test/testing/new";
Synonym created.
sys@ACME.WORLD> desc "test/testing/new"
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
X NUMBER(38)
sys@ACME.WORLD> desc test/testing/new
SP2-0565: Illegal identifier.
sys@ACME.WORLD> drop public synonym test/testing/new;
drop public synonym test/testing/new
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
sys@ACME.WORLD> drop public synonym "test/testing/new";
Synonym dropped.
sys@ACME.WORLD>
Bookmarks