IDENTIFY THE TABLESPACE IN WHICH THE TABLE RESIDES, THE SIZE OF THE EXTENT, THE FILE NUMBER THE EXTENT IS IN, AND WHICH BLOCK OF THE FILE THE EXTENT STARTS AT

3.

Identify the tablespace in which the table resides, the size of the extent, the

file number the extent is in, and which block of the file the extent starts at:

select tablespace_name, extent_id, bytes, file_id, block_id

from dba_extents where owner='SYSTEM' and segment_name='TAB24';