Re: Using two servers simultaneously

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 01 Apr 2005 21:51:16 +0200
Message-ID: <7e9r41h8app2ah1gvcinb7lr3itemt62bn@4ax.com>

On 1 Apr 2005 11:47:51 -0800, "Sameer" <sameer75_at_gmail.com> wrote:

>Hello,
>I have two Oracle Servers in my network.
>I can log-on to both of them using different host-strings.
>But i can log onto one server at a time?
>How can I get access to data of both servers simultaneously?
>Is there any DSN stuff associated with it?
>Can I do it with command?
>Please help.
>-Sameer

Look up 'Distributed databases' and 'Database links' in your documentation.
Note: The database concept of sqlserver equates a *schema* in Oracle. You usually don't need multiple databases, especially if they are located on the same server, you are just wasting resources.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Apr 01 2005 - 13:51:16 CST