Use sqlplus to output data in a table to a text file in a specified format

-- Use sqlplus to output data in a table to a text file in a specified format
Set term off -- remove Screen Display
Set feed off -- remove the number of lines displayed for output
Set pagesize 0 -- no page feed
Set linesize 2000 -- set the length of the row to ensure that the sum of the length of all the output fields is displayed.
Set space off -- set the number of spaces between output Columns
Set trims on -- Remove trailing Spaces
Spool E:/x.txt
Select sysdate | CHR (9) | table_name | CHR (9) | tablespace_name | CHR (9) | cluster_name | CHR (9) | iot_name | CHR (9) | pct_free | CHR (9) | pct_used | CHR (9) | duration | CHR (9) | skip_corrupt | CHR (9) | monitoring | CHR (9) | cluster_owner from user_tables;
Spool off
Exit