how-to get all tables info with sqlplus in Oracle

set colsep , -- separate columns with a comma
set pagesize 0 -- only one header row
set trimspool on -- remove trailing blanks
set headsep off -- this may or may not be useful...depends on your headings.
set linesize X -- X should be the sum of the column widths

spool all_tables.csv
-- GET TABLES INFO
SELECT owner , table_name FROM ALL_TABLES ;

-- SWITCH OFF THE SPOOL
spool off

exit ;