You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Public Properties

PropertyDescription

Buffer Pool property of the Partition. Input should be a string containing NONE, DEFAULT, KEEP, or RECYCLE. Not for HASH partitions. DATATYPE: String. 

Free 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.
  • No labels