Re: MAX_EXTENTS

In the DBA_TABLESPACE view, the column "max_extents" refers to the default storage paramters for any segment created in that specific TS without explicit storage settings,

so you can set the DEF to be max=400, but create a table TESTMAXEXT and give it storage ( maxextents 1012)

On Thu, 09 Nov 2000 10:05:47
 Terry Ball wrote:
>Because you have multiple segments in the tablespace, each
>with one or more extents of there own, but you have one
>segment that has 1017 extents all by itself.
>
>Terry
>
>"DEMANCHE Luc (Cetelem)" wrote:
>
>>
>>
>> Hi gurus,
>>
>> I noticed a little weird thing :
>>
>> FICOMOP> select max_extents from dba_tablespaces where tablespace_name
>> = 'TBS_TRAVAIL';
>>
>> MAX_EXTENTS
>> -----------
>> 1017
>>
>> FICOMOP> select count(*) from dba_extents where tablespace_name =
>> 'TBS_TRAVAIL';
>>
>> COUNT(*)
>> ----------
>> 19402
>>
>> Why the maximum number of extents defined in dba_tablespaces is 1017
>> and I have 19402 extents created in my tablespace.
>>
>> Is it the maximum number of extents per datafile or for the tablespace
>> ?
>>
>> TIA
>>
>> -----------------
>> Luc Demanche
>> CETELEM
>> Til.: 01-46-39-14-49
>> Fax : 01-46-39-59-88
>

Get FREE Email/Voicemail with 15MB at Lycos Communications at http://comm.lycos.com Received on Thu Nov 09 2000 - 12:41:03 CST