Oracle DBA 中无法查看表空间，是怎么回事？

Question

点击打开表空间就没反应了。。

Answer 1

SQL> desc v$tablespace;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TS#                                                NUMBER
 NAME                                               VARCHAR2(30)
 INCLUDED_IN_DATABASE_BACKUP                        VARCHAR2(3)
 BIGFILE                                            VARCHAR2(3)
 FLASHBACK_ON                                       VARCHAR2(3)
 ENCRYPT_IN_BACKUP                                  VARCHAR2(3)SQL> select TS#,NAME from v$tablespace;       TS# NAME
---------- ------------------------------
         0 SYSTEM
         1 UNDOTBS1
         2 SYSAUX
         4 USERS
         3 TEMP
         6 EXAMPLE
         5 UNDOTBS2
         7 TEST
        10 CC_DATA1
         9 CC_DATA
        11 CC_DATA2       TS# NAME
---------- ------------------------------
        12 CC_DATA3
        13 CC_DATA4
        14 CC_TEMP
        15 TS_VCMSDATA15 rows selected.

Answer 2

查看表空间信息
select*from dba_data_files