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;
No comments:
Post a Comment