Re: all_objects does not contain database link

I am running 9.2.0.6 and am getting the same result ... I've tested it with the following scripts Create public database link TO_DB1.WORLD connect to u1 identified by mypswd using 'dbx.world'; Create database link TO_DB2.WORLD
connect to u1 identified by mypswd using 'dbx.world';

select OBJECT_NAME, OBJECT_TYPE from USER_OBJECTS where OBJECT_TYPE ='DATABASE LINK';
OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------
TO_DB2.WORLD DATABASE LINK select OBJECT_NAME, OBJECT_TYPE from ALL_OBJECTS where OBJECT_TYPE ='DATABASE LINK';
no rows selected

And then using a dba account ...
Select OBJECT_NAME, OBJECT_TYPE from ALL_OBJECTS where OBJECT_TYPE ='DATABASE LINK';
no rows selected

Select OBJECT_NAME, OBJECT_TYPE from DBA_OBJECTS where OBJECT_TYPE ='DATABASE LINK';

OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------

TO_DB1.WORLD      DATABASE LINK
TO_DB2.WORLD      DATABASE LINK

The view all_db_links looks good though... Select * from all_db_links;
OWNER DB_LINK USERNAME HOST
------------ --------------- -------- --------------- ---------

PUBLIC    TO_DB1.WORLD    U1       dbx.world
XXX          TO_DB2.WORLD    U1       dbx.world

I don't why. Received on Tue Jan 11 2005 - 09:40:11 CST