next_special

This parameter defines the special sizes of next extent for exceptional tables and indexes, in KB, MB, or GB. You can use this parameter to specify your own sizes for next extents and maximum number of extents for selected tables and indexes.

Syntax:

next_special = [<owner>.]<table>:<size>[/<limit>],[<owner>.]

<index>:<size>[/<limit>]|(<special_list>)|[|<owner>.]<prefix>*:<size>

[/<limit>]|all_sel:<size>[/<limit>]

where

<size>: <n>K|<n>M|<n>G special NEXTEXTENT size

<limit>: special MAXEXTENTS count

all_sel: sets NEXTEXTENT and MAXEXTENTS attributes to a certain value for all the database objects selected using the -t function option of -f next or the next_table parameter. This option is provided for exceptional situations.

 

Default: According to table category

For more information, see Internal Rules for Determining Next Extent Size.