RE: Create Database Link in Oracle8

From: Gurgaon, DBA (CAP, GECSI, CONTRACTOR) <DBA.Gurgaon_at_geind.GE.com>
Date: Wed, 12 Jul 2000 11:28:44 +0530
Message-Id: <10555.111758@fatcity.com>

Keith

'connect string ' is what u use in connecting sql*plus on client to database. This connect string is defined in ur tnsnames.ora. Lets take the example of a entry in your tnsnames.ora.

DEBENTURE =
(DESCRIPTION =

        (ADDRESS = 


          (COMMUNITY = TCP)

          (PROTOCOL = TCP)

          (Host = 3.235.28.15)

          (Port = 1521)

        )
    (CONNECT_DATA = 
      (SID = DEB)
         (GLOBAL_NAME = DEB)

)
)

Here DEBENTURE is your 'connect string'. Now if you want to keep your dblink name to be differnt from your db_name than make
parameter 'global_names = false ' in your init<SID>.ora file .

Vikas

-----Original Message-----
From: Keith Shum [mailto:kshum_at_iLux.com] Sent: Wednesday, July 12, 2000 10:34 AM
To: Multiple recipients of list ORACLE-L Subject: Create Database Link in Oracle8

Hello, everyone,

I have a question like to ask about creating database link.

Both Server and Client database are Oracle8 (which using SID in tnsnames.ora, but not SERVICE_NAME).

And they are both on NT4.

How can I specify the "connect_string" in the CREATE DATABASE LINK statement as:

         CREATE DATABASE LINK link_name
            CONNECT TO username IDENTIFIED BY password
            USING 'connect_string';

Tried using DB_NAME.DB_DOMAIN there, no luck! Tried using SID only, still no luck! Tried using hostname:port:SID, no luck also!

Please help!!!!!!!!

--

Keith Shum

kshum_at_iLux.com

iLux Corporation
Phone (510) 226-5600 x 643
Fax (510) 226-8182
Cellular Phone (510) 435-0286
5600 Mowry School Road, Newark, CA 94560
http://www.iLux.com
Web site analysis for NT and Unix

"Share what you know. Learn what you don't." -- From Deja.com


-- 
Author: Keith Shum
  INET: kshum_at_iLux.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Wed Jul 12 2000 - 00:58:44 CDT