Null object_id in user_objects

When will Oracle have a null object_id, even if the doc says it’s NOT NULL?

An invalid database link.

An update: Actually, any database link.
It comes from the second branch of the union-all clause of user_objects:
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’);

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: