Re: from database to another database data load

From: Matt Southcott <matts_at_xxxnifcosynergy.com>
Date: 1997/10/21
Message-ID: <344d07fa.69806406@news.bctel.net>#1/1

As far as I can tell you want to copy some data from one table to an identical(or group of feilds) in another database. If I am correct in assuming this the best way to go about this is by using COPY.

try this

log into the server that you want to copy the table TO not where it currently resides. This command will recreate the table and populate it according to the SELECT statement

SQLPLUS>set copycommit 1
SQLPLUS>set arraysize 1000
SQLPLUS>COPY FROM remote_user/remotepassword_at_connect string

CREATE your table
USING
SELECT blah blah blah

There many options for this COPY command if you need more info try the online manuals or a DBA book that is where I found it.

Hope this helps.

On Sat, 18 Oct 1997 21:31:06 -0500, "Glenn dela Cruz" <glendc_at_sprint.ca> wrote:

>
>does anyone tell me how to load data from one oracle database to another
>oracle database.
>
>assuming:
>database A is the source
>database B is the destination
>
>database B fields to be populated are C,D,E
>database A fileds to be loaded to database A are F,G,H
>
>these fields have same data types
>
>can i use this?
>
>insert into table B(C,D,E)
>values(select F,G,H from A);
>
>i tried it, but it is not working. Is there a better way?
>
>help! I'm a novice oracle programmer...
>
>please email me..
>
>thank you,
>Glenn
>glendc_at_sprint.ca
>
>
>
>
Received on Tue Oct 21 1997 - 00:00:00 CDT