DBA Data[Home] [Help]

SYS.DBMS_FEATURE_DEFERRED_SEG_CRT dependencies on LOBFRAG$

Line 98: from lobfrag$ lf where lf.fragtype$='P'

94: -- segment_created = 'NO';
95:
96: select count(*) into lobpart_count from
97: ( select decode(bitand(lf.fragflags, 33554432), 33554432, 'NO', 'YES') x
98: from lobfrag$ lf where lf.fragtype$='P'
99: ) where x = 'NO';
100:
101: -- table sub-partitions
102: -- select count(*) into tabsubpart_count from dba_tab_subpartitions where

Line 125: from lobfrag$ lf where lf.fragtype$='S'

121: -- segment_created = 'NO';
122:
123: select count(*) into lobsubpart_count from
124: ( select decode(bitand(lf.fragflags, 33554432), 33554432, 'NO', 'YES') x
125: from lobfrag$ lf where lf.fragtype$='S'
126: ) where x = 'NO';
127:
128: -- Total segments of objects which can have deferred segment creation
129: -- select count(*) into total_segments from dba_segments where