Re: How many extents allowcated to a table?

From: <attwoody_at_my-dejanews.com>
Date: Fri, 22 Jan 1999 02:21:35 GMT
Message-ID: <788nb7$otm$1@nnrp1.dejanews.com>

In article <36a54096.19631889_at_news.mindspring.com>, crd1_at_mindspring.com (Craig Duncan) wrote:
> A simple dba question (I think!)
>
> How does one find out the number of extents that have been
> allocated to a table?
>
> Thanks,
> Craig Duncan
>

Greetings, Craig,

If you want to see what MAXEXTENTS have been allocated to a table -

select MAX_EXTENTS from dba_tables where table_name = your-table-name; or - if it's your own table

select MAX_EXTENTS from user_tables where table_name = your-table-name;

If you want to see how many extents a table is in -

select EXTENTS from dba_segments where SEGMENT_NAME = your-table-name and SEGMENT_TYPE = 'TABLE'; hope this helps

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Jan 21 1999 - 20:21:35 CST