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.
FreeListsFree Lists property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.
GUIDGUID of the Partition. DATATYPE: String.
HighValuesFor type RANGE, the are the HighValues of the Partition. For type LIST, this is the List of Values of the Partition. DATATYPE: String.
IDID of the Partition. DATATYPE: Integer.
InitExtentInitial Extent property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.
InitTransInitial Transaction property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.
MaxExtentsMax Extents property of the Partition. Input should be a string containing non-negative integer or UNLIMITED. Not for HASH partitions. DATATYPE: String.
MaxTransMax Transaction property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.
MinExtentsMin Extents property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.
NameName of the Partition. DATATYPE: String.
NextExtentNext Extent property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.
NoLoggingIndicates whether the operation is logged in the redo file. Not for HASH partitions. DATATYPE: Boolean.
NumberNumber of the Partition. Partition Numbers determine the order in which the partitions appear in the DDL. DATATYPE: Integer.
PctFreePctFree property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.
PctIncreasePercent Increase property of the Partition. Input should be a non-negative integer. Not for HASH partitions. DATATYPE: Integer.
TablespaceTablespace of the Partition. DATATYPE: String.
  • No labels