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

Compare with Current View Page History

« Previous Version 4 Current »

Public Methods

MethodDescription
OracleTableSubpartitionsReturns the collection of Oracle partition level subpartitions of the parent partition.

Public Properties

PropertyDescription
BufferPoolBuffer Pool property of the Partition. Valid values are: 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, these 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.

Determines whether the operation will be 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.

PctUsed 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