Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: When to expect the next extent of table?
Also, make sure there is enough space for the next extent. Use a query like this:
select tablespace_name,
owner, segment_name, segment_type, next_extent
(select 'x'
from dba_free_space b
where a.tablespace_name = b.tablespace_name
and b.bytes >= a.next_extent)
order by tablespace_name,segment_name
-- Paul In article <6uevf0$t7a$1_at_newton2.pacific.net.sg>, "Ng TC" <tcng_at_yas.com.sg> wrote:Received on Fri Sep 25 1998 - 00:00:00 CDT
>
> Hi,
>
> How do I check if a table (or other objects) will be creating the next
> extent (which dynamice views, dba_ views??)?
>
> How do I check how much of the current extent is being used?
>
> Thanks in advance.
>
> Regards,
> Tse Chong
>
> (Please reply trhough email: tcng_at_yas.com.sg )
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum