all_objects does not contain database link

From: <georgejzhang_at_gmail.com>
Date: 11 Jan 2005 07:04:12 -0800
Message-ID: <1105454699.315226.167300@f14g2000cwb.googlegroups.com>

Hello,

I am running Oracle 9.2.0.4, and just found that all_objects does not contain list of database links:

Logged in as a user who has database link:

SELECT object_name, object_type FROM all_objects WHERE object_type =
'DATABASE LINK';
no rows selected

SELECT object_name, object_type FROM user_objects WHERE object_type =
'DATABASE LINK';

OBJECT_NAME                     OBJECT_TYPE
---------------------------     --------------
XXXX                            DATABASE LINK
XXXX                            DATABASE LINK

2 rows selected

It does not make much sense. Is it just me or what ? Thanks for your help.

George Received on Tue Jan 11 2005 - 09:04:12 CST