Re: how to transfer data between two database

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 8 Dec 1999 23:12:34 +0100
Message-ID: <944691199.6747.0.pluto.d4ee154e@news.demon.nl>

What about creating a database link and using sql*plus insert into table_at_remote-loc
select columns
from localtable

Using sql*loader would be ridiculous.

Hth,

--
Sybrand Bakker, Oracle DBA
<susil99_at_my-deja.com> wrote in message news:82mdpm$msk$1_at_nnrp1.deja.com...
> I trying to transfer data from one oracle database table to another
> oracle database in different location. The table scheme are diffrent.
> only some of fields data need to go the destinaton table. IS sql loader
> is fine with some java process invoking it or is there any other
> reliable way to do it.
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Dec 08 1999 - 16:12:34 CST