怎么列出所有的表空间？

Question

select * from v$tablespace;

Answer 1

SQL> desc dba_tablespaces;
 Name                                      Null?    Type
 ----------------------------------------- -------- -----------------------
 TABLESPACE_NAME                           NOT NULL VARCHAR2(30)
 INITIAL_EXTENT                                     NUMBER
 NEXT_EXTENT                                        NUMBER
 MIN_EXTENTS                               NOT NULL NUMBER
 MAX_EXTENTS                               NOT NULL NUMBER
 PCT_INCREASE                              NOT NULL NUMBER
 MIN_EXTLEN                                         NUMBER
 STATUS                                             VARCHAR2(9)
 CONTENTS                                           VARCHAR2(9)
 LOGGING                                            VARCHAR2(9)SQL> select distinct tablespace_name from dba_tablespaces;TABLESPACE_NAME
------------------------------------------------------------
INDX
PMDATA
PMINDEX
PMTEMP
SYSTEM
TBS_RBS
TEMP
TOOLS
USERS