Re: How to find extents of table

You will need to use user_segments (where the segment_name equals your table_name as a segment is the physical representation of a table), user_segments has a column extents.
You will also need to use user_tables, provided the table is analyzed. There is a column empty_blocks which tells you how many blocks have not been used.

Hth,

Sybrand Bakker, Oracle DBA

Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca> schreef in berichtnieuws 394149fe_at_news.victoria.tc.ca...
> Hello.
>
> I would like to know how to find the number of extents currently allocated
> to a table, and the number of extents actually used by the table.
>
> I assume that a column(s) in user_tables or all_tables shows this
> information, but I'm not sure which one(s).
>
> My purpose is simply to choose a sensible initial extent for another,
> similar, system that is going to receive a copy of the table.
>
> If you know I would appreciate being told, thanks.
>
> malcolm
Received on Fri Jun 09 2000 - 00:00:00 CDT