Re: extents of a table

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 05 Aug 1999 20:23:34 +0800
Message-ID: <37A98246.229C@yahoo.com>

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

Have a look at DBA_SEGMENTS and also DBA_EXTENTS which will have the size of each extent
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Aug 05 1999 - 07:23:34 CDT