Name

ALTER INDEX REBUILD PARTITION

Synopsis

ALTER INDEX
[schema.]index_name
REBUILD PARTITION partition_name
[INITRANS integer]
[MAXTRANS integer]
[PCTFREE integer]
[LOGGING | NOLOGGING]
[PARALLEL ( {DEGREE {integer | DEFAULT} |
INSTANCES {integer | DEFAULT} } ) ]
[NOPARALLEL]
[REVERSE | NOREVERSE ]
[TABLESPACE tablespace_name
[STORAGE (
      [NEXT integer[K | M] ]
      [MAXEXTENTS {integer | UNLIMITED} ]
      [PCTINCREASE integer]
      [FREELISTS integer]
      [FREELIST GROUPS integer]

Rebuilds the index partition using information from the current index (index_name). Allows you to change the physical attributes of existing indexed information.

Keywords

REBUILD PARTITION

Forces Oracle to rebuild the index partition.

INITRANS

Changes the initial number of transaction entries allocated to each block of the index.

MAXTRANS

Changes the maximum number of transaction entries allocated to each block of the index.

PCTFREE

Specifies the amount of free space left in each block for inserts and updates.

LOGGING

Specifies that the operation is to be logged to the redo logs.

NOLOGGING

Specifies that nothing is to be written to the redo logs for this operation.

PARALLEL

Specifies the level of parallelism to be supported, based on the following parameters:

DEGREE

Specifies the degree of parallelism. An integer value specifies how many slave processes can be used. Specify DEFAULT to use the default value for the tablespace.

INSTANCES

Specifies the number of instances that can be used to execute slave processes. Specify DEFAULT to use the default value specified for the tablespace.

NOPARALLEL

Specifies that no parallelism is to be used.

REVERSE

Specifies that Oracle will store the bytes of the index key in reverse order. This is useful in situations where rows are always added in increasing order to allow the index to grow evenly rather than only at one end. It is also useful in a Parallel Server environment, allowing individual instances to insert information in different blocks, thus reducing pinging.

NOREVERSE

Specifies that Oracle will not store the bytes of the index key in reverse order.

TABLESPACE

Specifies a new tablespace (tablespace_name) for the rebuilt index partition.

STORAGE

Specifies the physical characteristics of the index as follows:

NEXT

Specifies the size of the next extent in bytes, kilobytes, or megabytes. If the value is not a multiple of the database blocksize, it will be rounded up to a multiple of the database blocksize.

MAXEXTENTS

Specifies the maximum number of extents that may be allocated for this index. The default will vary according to the database blocksize. Specify UNLIMITED for unlimited expansion.

PCTINCREASE

Specifies the percentage by which each extent will grow over the previous extent. The default is 50, which means that each extent will be one-and-one-half times larger than the previous extent.

FREELISTS

Specifies the number of free lists contained in each freelist group in this index. The default is 1 and the maximum depends on the database blocksize.

FREELIST GROUPS

Specifies the number of groups of free lists for this index. The default is 1. This parameter should be used only with the Parallel Server option running in parallel mode.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.225.95.107