Re: Sending data between servers

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".

Paul Received on Sat Aug 18 2001 - 15:38:53 CDT