Re: db links in a database

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 20 Dec 2004 11:12:19 +0100
Message-ID: <cq68hd$e90$1@news2.zwoll1.ov.home.nl>

yls177 wrote:
> Hi, a select query does not return any hits for table ALL_DB_LINKS.
> Does that meant that there are no db links for this database?
>
> Please advise.

No.
As usual, the ALL_ views contain data about objects, which the user can 'see';
USR_ which the user owns
DBA_ which are all there (privileged information).

Use DBA_DB_LINKS instead (if you have privileges to query it).

-- 
Regards,
Frank van Bortel

Received on Mon Dec 20 2004 - 04:12:19 CST