请问Oracle中如何显示表空间的名字

Question

   我昨天建的表空间忘记起什么名字了，我现在想删除它，请问如何显示所有表空间的名字呢，我建立的是数据表空间

Answer 1

select * from dba_tablespace

Answer 2

select * from user_tablespaces

Answer 3

SQL> desc dba_data_files;
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ---------------------------- FILE_NAME                                          VARCHAR2(513)
 FILE_ID                                            NUMBER
 TABLESPACE_NAME                                    VARCHAR2(30)
 BYTES                                              NUMBER
 BLOCKS                                             NUMBER
 STATUS                                             VARCHAR2(9)
 RELATIVE_FNO                                       NUMBER
 AUTOEXTENSIBLE                                     VARCHAR2(3)
 MAXBYTES                                           NUMBER
 MAXBLOCKS                                          NUMBER
 INCREMENT_BY                                       NUMBER
 USER_BYTES                                         NUMBER
 USER_BLOCKS                                        NUMBER
 ONLINE_STATUS                                      VARCHAR2(7)SQL> set wrap off
SQL> select tablespace_name,file_name from dba_data_files;TABLESPACE_NAME                FILE_NAME
------------------------------ -------------------------------------------------USERS                          D:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF
UNDOTBS1                       D:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF
SYSAUX                         D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF
SYSTEM                         D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF
DAVE                           D:\APP\ADMINISTRATOR\ORADATA\ORCL\DAVE0.DBF------------------------------------------------------------------------------ 
Blog： http://blog.csdn.net/tianlesoftware 
网上资源： http://tianlesoftware.download.csdn.net 
相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx 
DBA1 群：62697716(满); DBA2 群：62697977

Answer 4

--也可以这样
  1* select distinct tablespace_name from user_tables
SQL> /TABLESPACE_NAME
------------------------------SYSAUX
MYTS
MYDATA
SYSTEM