Versions Compared

Key

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

Public Methods

MethodDescription
AddAdd a new OracleIndexPartition object. PARAMETERS: HighValues (String).
AddColumnToPartitionKeyAdd another column to the partition key. For type LIST, the passed in column replaces the previous column. PARAMETERS: Name (String).
DeleteColumnFromPartitionKeyDelete a column from the partition key. Cannot delete last column in key. PARAMETERS: Name (String).
DeletePartitionKeyDelete all columns in the partition key. This also deletes all partitions and all subpartitions and the subpartition key.
GetPartitionColumnNumberLooks for the column in the partition key. If found, it returns the column's number. PARAMETERS: Partition Column Name (String). RETURN DATATYPE: Integer.
RemoveRemove a OracleIndexPartition specified by the given Number. PARAMETERS: Number (Integer).
RemoveByNameRemove the OracleIndexPartition specified by the given Name. PARAMETERS: Name (String).
SetPartitionColumnNumberChange the sequence of the columns in the partition key by setting the number of a column. PARAMETERS: Partition Column Name (String), Number (Integer).

Public Properties

PropertyDescription
_ItemReturns an OracleIndexPartition object specified by the given Number or GUID. PARAMETERS: Identifier (Integer or String).
_NewEnum
CountNumber of OracleIndexPartition objects in the collection. DATATYPE: Integer.
GetPartitionKeyColumnsNames of the columns in the PartitionKey as a comma-separated list in sequence order. DATATYPE: String.
HashPartitionCountNumber of hash partitions when the index is partitioned by quantity. DATATYPE: Integer.
HashPartitionTablespacesTablespaces where the index hash partitions should be stored. DATATYPE: String.
IsGlobalDetermines whether the indexes scope is global or local. DATATYPE: Boolean.
ItemReturns an OracleIndexPartition object specified by the given Number or GUID. PARAMETERS: Identifier (Integer or String).
PartitionTypeType of index partition used to partition the index for Oracle 10 and later versions. DATATYPE: String.
Info
titleSee Also