DBA Data[Home] [Help]

SYS.AD_ZD_SYS dependencies on OBJ$

Line 313: 88, decode((select d.type# from sys.obj$ d

309: 11, 'PACKAGE BODY',
310: 12, 'TRIGGER',
311: 13, 'TYPE',
312: 14, 'TYPE BODY',
313: 88, decode((select d.type# from sys.obj$ d
314: where d.obj# = obj.dataobj#),
315: 4, 'VIEW',
316: 5, 'SYNONYM',
317: 7, 'PROCEDURE',

Line 328: sys.obj$ obj

324: 14, 'TYPE BODY')) object_type
325: , obj.namespace namespace
326: , obj.obj# object_id
327: from
328: sys.obj$ obj
329: , ( select
330: xusr.user#
331: , xusr.ext_username user_name
332: , ed.name edition_name

Line 335: , (select * from sys.obj$

331: , xusr.ext_username user_name
332: , ed.name edition_name
333: from
334: (select * from sys.user$ where type# = 2) xusr
335: , (select * from sys.obj$
336: where owner# = 0 and type# = 57) ed
337: where xusr.spare2 = ed.obj#
338: union
339: select

Line 345: , (select * from sys.obj$ where owner#=0 and type#=57) ed

341: , busr.name user_name
342: , ed.name edition_name
343: from
344: (select * from sys.user$ where type#=1 or user#=1) busr
345: , (select * from sys.obj$ where owner#=0 and type#=57) ed
346: where ed.name = 'ORA$BASE' ) eusr
347: where obj.owner# = eusr.user#
348: and obj.type# not in (10, 0)
349: and obj.remoteowner is null ) co