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: Sending data between servers

Re: Sending data between servers

From: Carson <nospam_at_newsranger.com>
Date: Sat, 18 Aug 2001 21:44:04 GMT
Message-ID: <EkBf7.6325$2u.55161@www.newsranger.com>


Thanks, I appreciate the response, I'll give it a try when this all gets going.

Carson

In article <3B7ED248.8428745C_at_home.com>, Paul Drake says...
>
>Carson wrote:
>>
>> I hope someone can point me in a direction on this. I have an oracle server
>> running on a solaris box and another at a different
>> location running on an hpux box. I need to extract data from the db on the
>> solaris box and insert the data into
>> the database running on the hpux box. Of course I can do this through a CORBA
>> connection with a process running on
>> each box but there seems to be some hostility to this, a political thing. Any
>> alternative ideas are welcomed. Thanks
>> Carson
>>
>> Carson Wilcox
>> carson_wilcox_at_yahoo.com
>
>http://tahiti.oracle.com/pls/tahiti/tahiti.tabbed?section=75351
>
>1. populate the tnsnames.ora file for the connections that you wish to
>use.
>2. create a database link
>
>CREATE DATABASE LINK <dblink_name>
> CONNECT TO <user>
> IDENTIFIED BY <password>
> USING '<connect string>';
>
>Notes:
>
>- its best if you don't make the link public.
>- the password will be visible in the view DBA_DB_LINKS
> so its best if users do not have the sys_priv "SELECT ANY TABLE"
>- data type "LONG" is not supported across a db_link - use sql*plus
>"COPY".
>
>hth,
>
>Paul

Carson Wilcox
carson_wilcox_at_yahoo.com Received on Sat Aug 18 2001 - 16:44:04 CDT

Original text of this message

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