Re: Extents, current and max

From: <sriviswa_at_hotmail.com>
Date: Thu, 11 Nov 1999 00:11:39 GMT
Message-ID: <80d1jn$nsp$1@nnrp1.deja.com>

SELECT SEGMENT_NAME, EXTENTS, MAX_EXTENTS FROM DBA_SEGMENTS
/
In article <80cuga$lj6$1_at_nnrp1.deja.com>, lbellamy_at_fincen.uscg.mil wrote:
> I need an SQL query that will give me the following information in one
> statement.
>
> segment_name ...current_no_of_extents ... max_extents
>
> I can obtain this info with two queries, however I just want to issue
> one.
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 10 1999 - 18:11:39 CST