how to reference database link without domain name?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to reference database link without domain name?

  1. #1
    Join Date
    Apr 2001
    Posts
    125

    how to reference database link without domain name?

    Hi, it is the first time I have this kind of problem, I created a new 10g instance yesterday, in one of the schema I need to reference tables in another instance - TEST2, so I created a db link:

    create database link ODW.REGRESS.RDBMS.DEV.US.ORACLE.COM
    connect to testdb identified by testdb
    using 'TEST2';

    I swear I can reference the table without domain name in 10g before, like this:

    select * from tab1@odw

    but not this time, it seems that I have to use the full name:

    select * from tab1@ODW.REGRESS.RDBMS.DEV.US.ORACLE.COM

    and it seems that if I wan to use tab1@odw, I have to create another db link:

    create database link ODW
    connect to testdb identified by testdb
    using 'TEST2';

    anyone has the same problem before?
    Oracle 8, 8i, 9i OCP DBA
    Oracle 6/6i OCP DEV
    Sun Solaris8 SCSA
    MCDBA 2000

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    didnt you see what you called the dblink? you called it as name, then get surprised when you have to reference it by that name

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    Are you connecting to a server at Oracle? Do you work there? If not, what is the purpose of using a bogus domain name?

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