Re: from database to another database data load

try this

insert into table X
as select... from Y;

there is an example of this in the oracle sql command guide, just look at the "insert" command.

Matt Southcott wrote:
>
> 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 Wed Oct 22 1997 - 00:00:00 CDT