Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Public Properties

PropertyDescription
BufferPoolBuffer Pool property of the Partition. Input should be a string containing NONE, DEFAULT, KEEP, or RECYCLE. Not for HASH partitions. DATATYPE: String. 
FreeListGroupsFree List Groups property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.

Free Lists property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.

GUID of the Partition. DATATYPE: String.

For type RANGE, the are the HighValues of the Partition. For type LIST, this is the List of Values of the Partition. DATATYPE: String.

ID of the Partition. DATATYPE: Integer.

Initial Extent property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.

Initial Transaction property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.

Max Extents property of the Partition. Input should be a string containing non-negative integer or UNLIMITED. Not for HASH partitions. DATATYPE: String.

Max Transaction property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.

Min Extents property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.

Name of the Partition. DATATYPE: String.

Next Extent property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.

Indicates whether the operation is logged in the redo file. Not for HASH partitions. DATATYPE: Boolean.

Number of the Partition. Partition Numbers determine the order in which the partitions appear in the DDL. DATATYPE: Integer.

PctFree property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.

Percent Increase property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.

Tablespace of the Partition. DATATYPE: String.
Info
titleSee Also