Set Feedback Off
Set Echo Off
Set Heading Off
Set Term Off

Column Instance New_Value _Instance NoPrint
SELECT 'OTS_' || name Instance FROM v$database;

spool &&_instance..txt;

-- Check TableSpace Status (Online|Offline)

select tablespace_name, status from dba_tablespaces;

spool off;
Set Feedback On
Set Echo On
Set Heading On
Set Term On

exit;