Re: How many extents have been allocated?

From: Doktor <doktor_at_post.pl>
Date: Wed, 20 Jan 1999 10:00:18 +0100
Message-ID: <36A59B22.C2E24FB@post.pl>

select extents from dba_segments where segment_name=<table_name> and segment_type='TABLE';

Regards,
Sebastian.

Shawn Lenhardt wrote:
>
> This is probably basic dba stuff:
>
> How do you determine how many extents have been allocated
> to a table?
>
> I can't seem to locate an appropriate view. A calculation?

--
mailto:doktor_at_post.pl
PGP Public Key : http://friko6.onet.pl/pr/bienkiew/

or mailto:bienkiew_at_netscape.net (mail robot) Received on Wed Jan 20 1999 - 03:00:18 CST