tablespace full problem

From: Lee Ming Fai <leemingf_at_pacific.net.hk>
Date: Fri, 9 Jul 1999 16:43:08 +0800
Message-ID: <7m4cld$ce212@news.hk.linkage.net>

I use the following sql to check the free space in each tablespace datafile :

select t1.file_id, t1.tablespace_name, ti.bytes,sum(t2.bytes)

from dba_data_files t1,dba_free_space t2 where t1.file_id=t2.file_id
group by t1.file_id, t1.tablespace_name, t1.bytes order by t1.tablespace_name, t1.file_id;

FILE_ID TABLESPACE_NAME BYTES FREE BYTES

------- --------------- ------------- ----------------
     11 CIND_TS         1,048,576,000      149,708,800

and found that one of the tablespace call CIND_TS has 149,708,800 bytes free.

The problem is I found an error message in the alert log, an index which the next extent is only 25M was unable to entend in this tablespace!

can anyone tell me how to solve this problem? Thanks! Received on Fri Jul 09 1999 - 03:43:08 CDT