Re: NEXT usage in CREATE TABLESPACE statement

ora_question_at_yahoo.co.uk wrote:
>
> mm, but why then is this NEXT still used in examples of Don Burleson,
> for instance here http://www.fast-track.cc/10g_02.htm
>
> that article obviously deals with Oracle 10g..
>
> is there a way how to specify the size of the initial extent with
> locally managed tablespaces using AUTOALLOCATE?
>
> all answers welcome :)
>

In the article by Burleson that you posted above, the NEXT clause is for the autoextension of the datafiles, not for the size of the next extent of a segment stored within that tablespace.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown