Public Synonym
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Public Synonym

  1. #1
    Join Date
    Aug 2003
    Location
    Some where in desert !!!
    Posts
    1

    Public Synonym

    hi all,

    COuld anybody tell me pls. how to drop the PUBLIC synonym in oracle 8i.. syntax pls...

    Thanks...

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131


    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Apr 2003
    Location
    In torment, in hell
    Posts
    18
    I don't think you can drop that, mate.

  4. #4
    Join Date
    Aug 2003
    Location
    TN
    Posts
    1
    Ummmm.....

    Not unless you wanted to type:

    drop public synonym [user.]synonym_name
    Last edited by BirdRacer; 08-06-2003 at 05:31 PM.

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by BirdRacer
    Ummmm.....

    Not unless you wanted to type:

    drop public synonym [user.]synonym_name
    Ummm.....

    Don't know what you mean by that (optional) "USER." part. Public synonym is public, meaning no user realy owns it. So if you try to stick that "user." part in the syntax, you defenitely won't be able to drop public synonym..... So it's just
    Code:
    drop public synonym synonym_name;
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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