Extent detection solution

From: mala singh <mala_singhm_at_hotmail.com>
Date: Fri, 03 Nov 2000 18:28:13 GMT
Message-Id: <10669.121102@fatcity.com>

Hi DBAS
I found some of objects has problem with next extents detection by using following query.

sql> select segment_name,a.segment_type,a.tablespace_name ,a.next_extent
from dba_segments a where a.next_extent > (select max(b.bytes) from dba_free_space b
where a.tablespace_name=b.tablespace_name group by b.tablespace_name);

Some of object has problem.
How to solve this problem.
solution path :
1)Export/drop/recreate object with larger initial setting and import objects

2)If the tablespace is full then add datafiles to the TS. But in existing database data files are autoextensible mode. what will be best solution.please suggest. Thnaks

Mala

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at http://profiles.msn.com. Received on Fri Nov 03 2000 - 12:28:13 CST