Oracle table data file

/* Formatted on 26/1/2023 6:08:15 pm (QP5 v5.391) */
SELECT 'alter database datafile ''' || file_name || ''' resize ' || CEIL ((NVL (hwm, 1) * &&blksize) / 1024 / 1024) || 'm;'     cmd
  FROM dba_data_files  a,
       (  SELECT file_id, MAX (block_id + blocks - 1) hwm
            FROM dba_extents
        GROUP BY file_id) b
 WHERE a.file_id = b.file_id(+) AND CEIL (blocks * &&blksize / 1024 / 1024) - CEIL ((NVL (hwm, 1) * &&blksize) / 1024 / 1024) > 0

tablespace