Re: extents of a table

A copy of this was sent to ck_at_ub.fu-berlin.de (Christoph Krempe) (if that email address didn't require changing) On Thu, 05 Aug 1999 10:20:43 GMT, you 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".
>

a table is a SEGMENT with a segment_type of TABLE.

select * from DBA_SEGMENTS where segment_name = 'YOUR TABLE NAME' and owner = USER and segment_type = 'TABLE';

>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

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Aug 05 1999 - 07:07:49 CDT