Show TOC

Syntax documentationnext_special Locate this document in the navigation structure

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 Syntax

  1. next_special =  [<owner>.]<table>:<size>[/<limit>],[<owner>.]
  2. <index>:<size>[/<limit>]|(<special_list>)|
  3. [|<owner>.][<prefix>]*[<suffix>]:<size>
  4. [/<limit>]|all_sel:<size>[/<limit>]
End of the code.

Default value: according to table category

Possible values:

  • <size> <n>K|<n>M|<n>G: special NEXT_EXTENT size

  • <limit>: special MAX_EXTENTS count

  • all_sel: sets NEXT_EXTENT and MAX_EXTENTS 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.

For more information, see: