Need help with next extent

Hi,

I am using Oracle 8.0.6 on windows Platform.

Recently i faced a situation where i got an error : ORA-01653: unable to extend table ultgnp.A_PT_ORDREG by 192000 in tablespace ULTGNP.  Then I created a new datafile under the tablespace ULTGNP approx sized 2 GB.

When i ran the following query today:

SQL> select s.owner
  2  ,s.segment_type
  3  ,s.segment_name
  4  ,s.tablespace_name
  5  ,s.next_extent/1024/1024 req
  6  ,maxtspace.max/1024/1024 maxfree
  7  from dba_segments s, (select tablespace_name,max(fsu.bytes) max
  8     from dba_free_space fsu
  9     group by tablespace_name) maxtspace
 10  where s.tablespace_name = maxtspace.tablespace_name
 11  and segment_type IN ('TABLE','INDEX','CLUSTER','TABLE PARTITION','INDEX PARTITION')