DBA Data[Home] [Help]

SYS.DBMS_FEATURE_SECUREFILES_USR dependencies on LOBCOMPPART$

Line 33: from lobfrag$ lf, lobcomppart$ lc, lob$ l, tab$ t, obj$ o

29: o.owner# not 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
34: where decode(bitand(lf.fragpro, 2048), 0, 'NO', 'YES')='YES' and
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