Oracle statements for querying user occupied space and clearing space

Set newpage none heading off space 0 PAGESIZE 0 trimout on trimspool on linesize 2500 colsep | feedback off termout off pages 0
Set colsep |
Alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss ';
Spool deltab. SQL
Select 'truncate table' | tname | 'drop store' | ';' from tab
Where TNAME not like '% TB %'
And TNAME like '% LZW % ';
Spool off;
Exit;

Set newpage none heading off space 0 PAGESIZE 0 trimout on trimspool on linesize 2500 colsep | feedback off termout off pages 0
Set colsep |
Alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss ';
Spool lzw_tablespace.txt
Select a. segment_name | '| sum (BYTES)/1024/1024 |' from user_segments
Group by a. segment_name
Order by sum (BYTES)/1024/1024 desc;
Spool off;

Nohup sqlplus ZJLZ/xx @ szj @ deltab. SQL> deltab. log &