一个表空间的信息在dba_data_files存在，却在dba_free_space中找不到

[hahano2]

如题，我创建了个表空间xxx，select * from dba_data_files where tablespacename='xxx'有数据，
却select * from dba_free_space where tablespacename='xxx'没数据
什么原因？

[CathySun118]

表空间满了？

[mmqingfeng]

就是表空间满了

[zcs_1]

给你个脚本,在sql*plus下执行,可以看到表空间的使用情况:

COLUMN "Tablespace" format a13
COLUMN "Used MB" format 99,999,999
COLUMN "Free MB" format 99,999,999
COLUMN "Total MB" format 99,999,999

SELECT fs.tablespace_name "Tablespace",
(df.totalspace - fs.freespace) "Used MB",
fs.freespace "Free MB",
df.totalspace "Total MB",
ROUND (100 * (fs.freespace / df.totalspace)) "Pct. Free"
FROM (SELECT tablespace_name, ROUND (SUM (BYTES) / 1024 / 1024)
totalspace
FROM dba_data_files
GROUP BY tablespace_name) df,
(SELECT tablespace_name, ROUND (SUM (BYTES) / 1024 / 1024) freespace
FROM dba_free_space
GROUP BY tablespace_name) fs
WHERE df.tablespace_name = fs.tablespace_name;

[hahano2]

恩，试验了一下，确实如1楼二楼所说，也感谢各位，小弟分不多，大家就将就吧