-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|