查看数据文件的情况

-- 方法一
SQL> select file#,status,bytes,name
2 from v$datafile;

FILE# STATUS BYTES NAME
---------- ------- ---------- --------------------------------------------------
1 SYSTEM 419430400 D:ORACLEORADATAHUZCSYSTEM01.DBF
2 ONLINE 209715200 D:ORACLEORADATAHUZCUNDOTBS01.DBF
3 ONLINE 20971520 D:ORACLEORADATAHUZCCWMLITE01.DBF
4 ONLINE 20971520 D:ORACLEORADATAHUZCDRSYS01.DBF
5 ONLINE 156631040 D:ORACLEORADATAHUZCEXAMPLE01.DBF
6 ONLINE 26214400 D:ORACLEORADATAHUZCINDX01.DBF
7 ONLINE 20971520 D:ORACLEORADATAHUZCODM01.DBF
8 ONLINE 10485760 D:ORACLEORADATAHUZCTOOLS01.DBF
9 ONLINE 26214400 D:ORACLEORADATAHUZCUSERS01.DBF
10 ONLINE 39976960 D:ORACLEORADATAHUZCXDB01.DBF

10 rows selected.

-- 方法二
SQL> select file_name,tablespace_name,bytes,status
2 from dba_data_files;

FILE_NAME TABLESPACE_NAME BYTES STATUS
-------------------------------------------------- ------------------------------ ---------- ---------
D:ORACLEORADATAHUZCSYSTEM01.DBF SYSTEM 419430400 AVAILABLE
D:ORACLEORADATAHUZCUNDOTBS01.DBF UNDOTBS1 209715200 AVAILABLE
D:ORACLEORADATAHUZCCWMLITE01.DBF CWMLITE 20971520 AVAILABLE
D:ORACLEORADATAHUZCDRSYS01.DBF DRSYS 20971520 AVAILABLE
D:ORACLEORADATAHUZCEXAMPLE01.DBF EXAMPLE 156631040 AVAILABLE
D:ORACLEORADATAHUZCINDX01.DBF INDX 26214400 AVAILABLE
D:ORACLEORADATAHUZCODM01.DBF ODM 20971520 AVAILABLE
D:ORACLEORADATAHUZCTOOLS01.DBF TOOLS 10485760 AVAILABLE
D:ORACLEORADATAHUZCUSERS01.DBF USERS 26214400 AVAILABLE
D:ORACLEORADATAHUZCXDB01.DBF XDB 39976960 AVAILABLE

10 rows selected.

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17826/viewspace-912021/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17826/viewspace-912021/