RE: Copy command

From: Suhen Pather <Suhen.Pather_at_strandbags.com.au>
Date: Wed, 6 Dec 2000 16:56:05 +1100
Message-Id: <10701.123753@fatcity.com>

Hessu,

Make sure you have your tnsnames.ora file setup to reference the table in the remote database.
ORACLE_HOME/network/admin/tnsnames.ora

This is what the entry should look like for the remote sid dev

dev.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (PROTOCOL = TCP)

          (Host = servername)

          (Port = 1521)

        )
        )

    (CONNECT_DATA = (SID = dev)
    )
  )

copy from user/pass_at_dev create EMP(NAME,JOB,SAL) using select * from EMP_at_dev;

This will create the table EMP in the current database as a copy from the EMP table on dev.
To use the copy command you need to setup the alias in the tnsnames.ora file called dev.

HTH Suhen

-----Original Message-----
From: Heikki Jantunen [mailto:hjantunen_at_hotmail.com] Sent: Wednesday, December 06, 2000 3:51 PM To: Multiple recipients of list ORACLE-L Subject: Copy command

Hello all,

I am trying to use copy-command in order to copy from remote database. But I

cannot "connect" to remote db, always I wrote the command I got error: not connected to oracle.

I looked the syntax and it says net_service_name, what is this. How should I

define my tnsnames.ora, should I define my "destination" db also on the remote server.

I am using Oracle 8.1.6...

Any ideas...

Thanks in advance,

Hessu

---

---

Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Heikki Jantunen
  INET: hjantunen_at_hotmail.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 Tue Dec 05 2000 - 23:56:05 CST