DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: synonym for db links

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    synonym for db links

    can we create synonym for database links? if yes what is the syntax and procedure..
    J Gangadhar

  2. #2
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    i tried before on 8i but unfortunately cannot.. donno on 9i or 10g can or not.
    The man called Zorro

  3. #3
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    AFAIK you cannot have synonyms for dblinks.

    Srini

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    since when you cannot have synonyms for db links?!

  5. #5
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    sorry guys my fault, gave a wrong dblinkname and tried, just now realised it.

    pando, if i create a synonym for dblink then how do i specify my sql.

    select * from xyz@synonynname

    is the above stmt right?

    Srini

  6. #6
    Join Date
    Jan 2003
    Location
    india
    Posts
    175
    keep waiting;
    pando will try and answer you.

    why can't you try ?

  7. #7
    Join Date
    Jan 2001
    Posts
    3,134
    SQL> create public synonym dumbass for remote_schema.dumbass@db_link_name;


    This way you are creating a synonym locally for the remote table that you are accessing through the db_link.

    Get it?




    MH
    I remember when this place was cool.

  8. #8
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    Originally posted by Mr.Hanky
    SQL> create public synonym dumbass for remote_schema.dumbass@db_link_name;


    This way you are creating a synonym locally for the remote table that you are accessing through the db_link.

    Get it?




    MH
    Yea, This one will work.. Tried before as well...
    The man called Zorro

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