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

Home -> Community -> Usenet -> c.d.o.server -> Re: Transfer data from oracle to oracle using sqlplus only

Re: Transfer data from oracle to oracle using sqlplus only

From: EdStevens <quetico_man_at_yahoo.com>
Date: 30 Aug 2006 18:25:50 -0700
Message-ID: <1156987550.694610.280990@h48g2000cwc.googlegroups.com>

Heinz wrote:
> One oracle is on a domain in USA and the other oracle is on
> a domain in Germany. There is no connection between them,
> its all passworded out, ports blocked etc. All I have is remote
> desktop to both. (its a govt thing which explains the ridiculous
> scenario!)
> I have remote connection to both but can only do dos sqlplus
> on both. I cannot 'link' them. All I can do
> is copy clipboard text from one to the other, via remote
> desktop. I cant ftp, telnet, install, nothing except remote
> desktop with no internet connection on either.
> So, I want to get single rows from one oracle db and insert
> them into the same table on the other oracle db.
>
> Its not a lot of data, but rows from several tables, and I will
> do it a few times a week for different customer cases.

OK. Can you reach both databases from an Oracle client *on your desktop*? Install Oracle client software on your desktop machine and run sqlplus from there?

What are you using for remote desktop? Does this mean both db servers are running Windows? Received on Wed Aug 30 2006 - 20:25:50 CDT

Original text of this message

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