SELECT
SEGMENT_NAME, TABLESPACE_NAME, EXTENTS, BLOCKS, BYTES
FROM
DBA_SEGMENTS
WHERE
OWNER = 'xxDB_USERxx'
AND SEGMENT_TYPE = 'TABLE'
AND SEGMENT_NAME IN ( 'xxTABLE_NAMExx' ) ;
SELECT
SEGMENT_NAME, TABLESPACE_NAME, FILE_ID, BLOCK_ID, BLOCKS, BYTES
FROM
DBA_EXTENTS
WHERE
OWNER = 'xxUSER_NAMExx'
AND SEGMENT_TYPE = 'TABLE'
AND SEGMENT_NAME IN ( 'xxTABLE_NAMExx' ) ;