Re: extents of a table

Try this script:

Christoph Krempe wrote:

> Hey,
>
> which view shows me the number of extents of a table?
> dba_tables has no column "extents", dba_segments no column "table_name".
>
> Thanks,
>
> Ch. Krempe
>
> -----------------------------------------------------------
> Freie Universitaet Berlin Christoph Krempe
> Universitaetsbibliothek Systemverwaltung
> - Rechenzentrum - Tel: 030/8384583
> Garystrasse 39 Fax: 030/8384582
> 14195 Berlin http://www.ub.fu-berlin.de/~ck