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’);
Advertisement
