Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:FW:

Re:FW:

From: <dgoulet_at_vicr.com>
Date: Tue, 13 Mar 2001 07:16:16 -0800
Message-ID: <F001.002CAD55.20010313064026@fatcity.com>

Rajan,

    I'll make the assumption that there are no DB links between the instances (I'm making the assumption that a database and an instance are equal). Under this situation log in to the target instance and use the 'copy' command in SQL*Plus. The syntax is:

COPY FROM <USERNAME>/<PASSWORD>@<DATABASE_NAME> - CREATE/APPEND <TABLE_NAME> -
USING SELECT <COLUMN1>, <COLUMN2>,<ETC...> - FROM <TABLE_NAME_AT_REMOTE>;

Note: Make sure to use the dash ("-") as a line continuation character. Otherwise a carriage return executes the statement.

Dick Goulet

____________________Reply Separator____________________
Author: "andrey" <bronfin_at_visualtop.com>
Date:       3/13/2001 1:30 AM

  Dear list !

  Incase if I've 2 databases with different set of data and I want to extract data from few tables in database 1 and data from few tables in database 2 and put the extracted data into 3rd database how can I do it.   The query is simple select statement.

  Early help would be appreciated.

  REgards,
  Rajan

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<META content="MSHTML 5.00.2920.0" name=GENERATOR></HEAD>
<BODY>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=481232009-13032001>Dear

  list !</SPAN></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
  class=850551904-10032001>Incase if I've 2 databases with different set of data

  and I want to extract&nbsp;data from few tables in database 1 and data from   few tables in database 2 and put the extracted data into 3rd database how can   I do it.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=850551904-10032001>The
  query is simple select statement.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
  class=850551904-10032001></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
  class=850551904-10032001>Early help would be appreciated.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
  class=850551904-10032001></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
  class=850551904-10032001>REgards,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
  class=850551904-10032001>Rajan</SPAN></FONT></DIV></BLOCKQUOTE></BODY></HTML>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.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
also send the HELP command for other information (like subscribing).
Received on Tue Mar 13 2001 - 09:16:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US