Can any body explain this query to me? All I know is it's used for space bound objects. I have no Idea what that is. I ran the query and got the result below. Can any body tell me what's wrong with my tablespace and how to correct it? I know there is something wrong but I can't tell what it is.


QUESTION1
SQL> SELECT a.table_name, a.next_extent, a.tablespace_name
FROM all_tables a,
( SELECT tablespace_name, max(bytes) as big_chunk
FROM dba_free_space
GROUP BY tablespace_name ) f
WHERE f.tablespace_name = a.tablespace_name
AND a.next_extent > f.big_chunk

SQL> /

TABLE_NAME NEXT_EXTENT TABLESPACE_NAME
----------- ---------- ------- -------
EMPLOYEE 460800000 ORANGE

NOTE: This what I got after I queried the dba_segment view:
SQL>
1* select segment_name, segment_type, initial_extent, next_extent, max_extents,owner from dba_segments where segment_name = 'EMPLOYEE' and owner = 'JOSEPH'
SQL> /

SEGMENT_N SEGMENT_TYP INITIAL_EXTENT NEXT_EXTENT
--------- ----------- -------------- ----------- -
EMPLOYEE TABLE 460800000 460800000
-----
SEGMENT_OWNER MAX_EXTENTS
------------ -----------
JOSEPH 500


NOTE: This is the query is from dba_extents:
SEGMENT_NAME BYTES TABLESPACE_NAM OWNER
------------ -------- -------- -----------
EMPLOYEE 460800000 ORANGE JOSEPH



thanks,
charity