DBA Data[Home] [Help]

SYS.DBMS_FEATURE_SECUREFILES_SYS dependencies on USER$

Line 20: o.owner# in (select user# from user$

16: where l.obj#=t.obj# and
17: decode(bitand(l.property, 2048), 0, 'NO', 'YES')='YES' and
18: decode(bitand(t.property, 8589934592), 0, 'NO', 'YES')='NO' and
19: o.obj# = t.obj# and
20: o.owner# in (select user# from user$
21: where name in ('SYS', 'SYSTEM', 'XDB'))
22: union
23: select pl.tabobj#, pl.lobj#, fragobj#, parentobj#, fragtype$
24: from lobfrag$ lf, partlob$ pl, tab$ t, obj$ o

Line 29: o.owner# in (select user# from user$

25: where decode(bitand(lf.fragpro, 2048), 0, 'NO', 'YES')='YES' and
26: lf.parentobj#=pl.lobj# and pl.tabobj#=t.obj# and
27: decode(bitand(t.property, 8589934592), 0, 'NO', 'YES')='NO' and
28: o.obj# = t.obj# and
29: o.owner# in (select user# from user$
30: where name in ('SYS', 'SYSTEM', 'XDB'))
31: union
32: select l.obj#, lc.lobj#, fragobj#, parentobj#, fragtype$
33: from lobfrag$ lf, lobcomppart$ lc, lob$ l, tab$ t, obj$ o

Line 39: o.owner# in (select user# from user$

35: lf.parentobj#=lc.partobj# and l.lobj#=lc.lobj# and
36: t.obj#=l.obj# and
37: decode(bitand(t.property, 8589934592), 0, 'NO', 'YES')='NO' and
38: o.obj# = t.obj# and
39: o.owner# in (select user# from user$
40: where name in ('SYS', 'SYSTEM', 'XDB'))
41: );
42:
43: feature_boolean := feature_count;