strange problem: tablespace name can't find in DBA_FREE_SPACE
516171Jun 18 2007 — edited Jun 18 2007hi, all
there is a strange problem in my database.
tablespace "ERP" is a very important tablespace in my database,and there is about 16G size data in it. but it can't be found in DBA_FREE_SPACE.
my datatbase is 10g rac,is there any problem in my database ?
thanks!
SQL> select distinct tablespace_name from dba_free_space;
TABLESPACE_NAME
------------------------------
UNDOTBS1
SYSAUX
ERP01
SPC_YJ
USERS
SYSTEM
EXAMPLE
UNDOTBS2
ERPEN
9 rows selected.
SQL> select name from v$tablespace;
NAME
-------------------------------------------------------
SYSTEM
UNDOTBS1
SYSAUX
USERS
TEMP
EXAMPLE
UNDOTBS2
ERP --this tablespace cann't be found in DBA_FREE_SPACE
ERP01
SPC_YJ
ERPEN
11 rows selected.