Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: next extent query

Re: next extent query

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 17 Jun 2003 19:27:47 +0100
Message-ID: <3eef5fe6_2@mk-nntp-1.news.uk.worldonline.com>


"Phillip" <tienp_at_wholefoods.com> wrote in message news:3EEDDF63.DBF494BE_at_wholefoods.com...
> Hello,
>
> how would I find out the next extent of segments that are on a locally
> managed tablespace with autoallocate set? Doing a query on dba_segments
> or dba_tablespaces yields a null value for next_extent. Thanks in
> advance. Please copy tienp_at_wholefoods.com in your responses.
>

I think I'd avoid the question by using uniform extent sizes.

Regards,
Paul Received on Tue Jun 17 2003 - 13:27:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US