That is weird indeed. User_objects does show it.
--
Terry Dykstra
Canadian Forest Oil Ltd.
<georgejzhang_at_gmail.com> wrote in message
news:1105454699.315226.167300_at_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:42:00 CST
