Re: all_objects does not contain database link

From: Noel <tomekb_at_s_o_f_t_m_a_n.pl>
Date: Tue, 11 Jan 2005 16:53:18 +0100
Message-ID: <cs0t0s$5tl$1@atlantis.news.tpi.pl>

Użytkownik georgejzhang_at_gmail.com napisał:

> 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
>

ALL_OBJECTS View doesn't show DATABASE LINKs, but USER_OBJECTS does.

• part of USER_OBJECT VIEW responsible for links:

[..]
union all
select l.name, NULL, to_number(null), to_number(null),

        'DATABASE LINK',
        l.ctime, to_date(null), NULL, 'VALID', 'N', 'N', 'N'

from sys.link$ l
where l.owner# = userenv('SCHEMAID')

-- 
tomekb

Received on Tue Jan 11 2005 - 09:53:18 CST