Re: How many extents allowcated to a table?

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Wed, 20 Jan 1999 16:33:29 +0800
Message-ID: <36A594D9.D83@bhp.com.au>

Craig Duncan wrote:
>
> A simple dba question (I think!)
>
> How does one find out the number of extents that have been
> allocated to a table?
>
> Thanks,
> Craig Duncan

For total extents

select *
from dba_segments
where owner = ...
and segment_name = ...
and segment_type = 'TABLE'

For a list of the extents

select *
from dba_extents
etc

--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Wed Jan 20 1999 - 02:33:29 CST