Query To Get List Of Tablespaces Exist in an Oracle Database

Download(tslist.sql)

REM +======================================================================+
REM                    
REM File Name: tslist.sql
REM 
REM Description:
REM   Query To Get List Of Tablespaces Exist in an Oracle Database
REM   
REM Notes:
REM   Usage: sqlplus "/ as sysdba" @tslist.sql
REM   
REM +======================================================================+

clear columns
set lines 180
 set pages 100
 col BIGFILE for a10
 select TABLESPACE_NAME,STATUS,CONTENTS,BIGFILE from dba_tablespaces
 order by CONTENTS desc;