Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: extents of a table
In dba_segments, segment_name gives you the name of the table.
You can restrict the selection with segment_type='TABLE'.
Christoph Krempe a écrit dans le message <7obnqm$if8$1_at_fu-berlin.de>...
>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
Received on Thu Aug 05 1999 - 07:23:36 CDT