Public synonyms with same name
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Public synonyms with same name

  1. #1
    Join Date
    May 2002
    Posts
    22
    Hi,

    I have two tables named the same in two schema's that are in the same database. How can I create two public synonyms cos it complains saying it already exists. This could be a problem as the forms/reports have already been coded..

    Any ideas??

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You can not have two public synonyms with same name.

    Sanjay

  3. #3
    Join Date
    May 2002
    Posts
    22
    To explain more :-

    User OWN has a table called SUPPLIERS that already has a public synonym in database LIVE called SUPPLIERS.

    User VAL also has a table called SUPPLIERS (using different system storing diff data) and when I'm trying to create a public synonym SUPPLIERS so other users can access the data it complains saying public synonym already exists......

    How do I get round it??

  4. #4
    Hi,

    As far as I know you cannot have two public synonyms with the same name. Your only work around will be to rename the table/synonym and change the code!

    Sorry pal, someone else might have a better idea.......

    good luck,
    -Shyami

  5. #5
    Join Date
    Feb 2002
    Posts
    70
    Hi,

    You can't have two public synonyms with the same name, because these are owned by PUBLIC. They are not owned by the other schemas. Only way to go is to create public synonym with different name or create a private synonym.

    I hope it answered your problem.

    Thanks
    ________________
    ShanDJ

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