This discussion is archived
2 Replies Latest reply: Apr 5, 2013 2:51 PM by Osama_Mustafa RSS

Db Link

928200 Newbie
Currently Being Moderated
Hi ,

I have installed oracle 11g on my machine.

When i am creating dblink with the below query
CREATE DATABASE LINK ABC
CONNECT TO Username
IDENTIFIED BY password
USING 'instance name ';


It is created dblink like below.
ABC.IN.ORACLE.COM

I dont want to create dblink like above ,I want dblink is simply
ABC.

Is there any way?
  • 1. Re: Db Link
    sb92075 Guru
    Currently Being Moderated
    925197 wrote:
    Hi ,

    I have installed oracle 11g on my machine.

    When i am creating dblink with the below query
    CREATE DATABASE LINK ABC
    CONNECT TO Username
    IDENTIFIED BY password
    USING 'instance name ';


    It is created dblink like below.
    ABC.IN.ORACLE.COM

    I dont want to create dblink like above ,I want dblink is simply
    ABC.

    Is there any way?
    SELECT GLOBAL_NAME FROM GLOBAL_NAME;
    UPDATE GLOBAL_NAME SET GLOBAL_NAME = NULL;
  • 2. Re: Db Link
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Check
    Create Database Link Without Trailing Domain Name [ID 462024.1]

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points