DBA Data[Home] [Help]

SYS.AD_ZD_SYS dependencies on USER$

Line 334: (select * from sys.user$ where type# = 2) xusr

330: xusr.user#
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

Line 344: (select * from sys.user$ where type#=1 or user#=1) busr

340: busr.user#
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)