2 Replies Latest reply: Apr 5, 2013 4:51 PM by Osama_Mustafa RSS

    Db Link

    928200
      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
          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
            Check
            Create Database Link Without Trailing Domain Name [ID 462024.1]