DBA Data[Home] [Help]

SYS.DBMS_FEATURE_SFCOMPRESS_USR dependencies on LOBCOMPPART$

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

31: o.owner# not in (select user# from user$
32: where name in ('SYS', 'SYSTEM', 'XDB'))
33: union
34: select l.obj#, lc.lobj#, fragobj#, parentobj#, fragtype$
35: from lobfrag$ lf, lobcomppart$ lc, lob$ l, tab$ t, obj$ o
36: where decode(bitand(lf.fragpro, 2048), 0, 'NO', 'YES')='YES' and
37: decode(bitand(lf.fragflags, 57344), 0, 'NO', 'YES')='YES' and
38: lf.parentobj#=lc.partobj# and l.lobj#=lc.lobj# and
39: t.obj#=l.obj# and