|
extents
3 where segment_name = 'T_ITDBA_1'
4 and block_id not in (select dbms_rowid.rowid_block_number(rowid) block_id
5 FROM T_ITDBA_1);
SEGMENT_NAME EXTENT_ID BLOCK_ID BYTES BLOCKS
------------------------------ ---------- ---------- ---------- ----------
T_ITDBA_1 0 18560 65536 8
T_ITDBA_1 2 18576 65536 8
T_ITDBA_1 4 18592 65536 8
T_ITDBA_1 6 18608 65536 8
T_ITDBA_1 8 18624 65536 8
T_ITDBA_1 10 18640 65536 8
T_ITDBA_1 12 18656 65536 8
T_ITDBA_1 14 18672 65536 8
T_ITDBA_1 16 18688 1048576 128
T_ITDBA_1 17 18816 1048576 128
T_ITDBA_1 18 18944 1048576 128
SEGMENT_NAME EXTENT_ID BLOCK_ID BYTES BLOCKS
------------------------------ ---------- ---------- ---------- ----------
T_ITDBA_1 19 19072 1048576 128
T_ITDBA_1 20 19200 1048576 128
T_ITDBA_1 21 19328 1048576 128
T_ITDBA_1 22 19456 1048576 128
?
|