Oracle: show tablespaces 

Joined:
04/09/2007
Posts:
565

February 06, 2010 00:15:01
This query lists the tablespaces in Oracle:
SQL> select * from v$tablespace;

       TS# NAME                           INC BIG FLA ENC
---------- ------------------------------ --- --- --- ---
         0 SYSTEM                         YES NO  YES
         1 UNDO                           YES NO  YES
         2 SYSAUX                         YES NO  YES
         4 USERS                          YES NO  YES
         3 TEMP                           NO  NO  YES

SQL>
[ Comment  | Tags ]
 
Easy email testing with http://www.ximailstop.com