REM This script coalesce the tablespaces

set echo off feedback off verify off pages 0 termout off
spool /tmp/coalesce.sql
SELECT 'alter tablespace ' || tablespace_name || ' coalesce;'
FROM dba_tablespaces;
spool off
/