DBA Data[Home] [Help]

SYS.DBMS_FEATURE_SFDEDUP_SYS dependencies on LOBFRAG$

Line 25: from lobfrag$ lf, partlob$ pl, tab$ t, obj$ o

21: o.owner# in (select user# from user$
22: where name in ('SYS', 'SYSTEM', 'XDB'))
23: union
24: select pl.tabobj#, pl.lobj#, fragobj#, parentobj#, fragtype$
25: from lobfrag$ lf, partlob$ pl, tab$ t, obj$ o
26: where decode(bitand(lf.fragpro, 2048), 0, 'NO', 'YES')='YES' and
27: decode(bitand(lf.fragflags, 458752), 0, 'NO', 'YES')='YES' and
28: lf.parentobj#=pl.lobj# and pl.tabobj#=t.obj# and
29: decode(bitand(t.property, 8589934592), 0, 'NO', 'YES')='NO' and

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

31: o.owner# 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, 458752), 0, 'NO', 'YES')='YES' and
38: lf.parentobj#=lc.partobj# and l.lobj#=lc.lobj# and
39: t.obj#=l.obj# and