drop synonym
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: drop synonym

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    drop synonym

    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?

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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>
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width