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

Thread: DBlink Question... domians?

  1. #1
    Join Date
    Feb 2002
    Posts
    21

    Question DBlink Question... domians?

    I have just created a dblink between an 8i and 9i db. However, I have become slightly confused regarding domains...

    Db1
    Select * from global_name;
    _________________________________
    DB1.local

    db2
    select * from global_name;
    _________________________________
    db2

    I have set global_names = false on both databases but to get the db link working i had to reference db1 as db1.world...

    -------------------------------------------------------------------
    create database link db1.world connect to user1 identified by pass1 using 'DB1';
    -------------------------------------------------------------------

    why is this? I always thought turning the global_names=false meant you didn't have to do this...?

    Thanks in advance

    Kev



  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Probably the tnsnames.ora entry is with .world
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    May 2001
    Posts
    736
    Even though after making the global_names=false.When u create a database link it is appended with the default domain stored in the database at the time of its creation.That is even if u change the global_names this willn't have the effect on the default value means u can't make the global_names parameter as null.

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