Re: Distributed database

From: D.L. McKinnon <mckinnon_at_ix.netcom.com>
Date: 1997/05/12
Message-ID: <33779570.5C2A@ix.netcom.com>#1/1

Xfukk01_at_vse.cz wrote:
>
> I need to connect two Oracle servers which contain different data (we want
> to do joins between two tables but each one is on differnet server). Should
> I use database links? And if so how must I grant privileges for users from
> one server on the another one - or is there any possibility to create
> "global" users and roles for the whole distributed database.
> Thank you Karel FUKA

Just create a PUBLIC database link.
You can then access tables by select * from table_at_db_link;

D.L. McKinnon
Oracle DBA Received on Mon May 12 1997 - 00:00:00 CDT