| Current table extent [message #57017] |
Wed, 14 May 2003 22:08  |
Wanchun
Messages: 4
Registered: May 2003
|
Junior Member |
|
|
Please help.
I just can find the max_extents from the user_tables. However, how can i know the current extent of the table. Because, I need to know the table will be reached the max_extents or not, thanks.
Urgent!!!!
|
|
|
|
| Re: Current table extent [message #57022 is a reply to message #57017] |
Thu, 15 May 2003 03:24  |
Deepa
Messages: 269
Registered: November 2000
|
Senior Member |
|
|
hi,
u can use the following query to find out Extents reaching maximum
select owner "Owner", segment_name "Segment Name", segment_type "Type", tablespace_name "Tablespace", extents "Ext", max_extents "Max"from dba_segments where
((max_extents - extents) <= 3) and owner not in ('SYS','SYSTEM') order by owner, segment_name
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
