Oracle: show tablespaces
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>
Easy email testing with http://www.ximailstop.com