Brian Peasland schreef:
> 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
>
>
Which is exactly what the NEXT option of the AUTOEXTEND clause
does...
To the OP: your tablespace will have a datafile, whcih will be
created with a size of 262144000 bytes initially, and the file
is allowed to extend itself, with 5242880 bytes each time it is
needed (datafile full). There is no limit (other than OS) to
what size the datafile can grow (I know - oversimplification;
Oracle does have a limit on datafiles, but usually the OS kicks
in long before that)
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Tue Oct 10 2006 - 12:39:58 CDT
