Re: Number Of Extents on tables

From: holders <holders_at_demon.co.uk>
Date: 2000/08/04
Message-ID: <398ADBDB.CE11352F@demon.co.uk>#1/1

You must select from user_extents where segment_name = 'XXX'

The above will detal the extents allocated to your segment and sizes SH

Iain Wiseman wrote:

> I have set my table storage to be unlimited for sizing of tablespace. How do
> I find the number of extents used so that I can set the storage correctly.
>
> Iain
> --
> mailto:iwiseman_at_g8labs.co.nz
> ----------------------------------------------------------------------------
> -----
> For the sword outwears its sheath,
> And the soul wears out the breast,
> And the heart must pause to breathe,
> And Love itself have rest.
Received on Fri Aug 04 2000 - 00:00:00 CDT