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" <[EMAIL PROTECTED]>
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> </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 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> </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> </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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
