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

Compare with Current View Page History

« Previous Version 3 Current »

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

Returns an OracleIndexPartition object specified by the given Number or GUID. PARAMETERS: Identifier (Integer or String).



Number of OracleIndexPartition objects in the collection. DATATYPE: Integer.

Names of the columns in the PartitionKey as a comma-separated list in sequence order. DATATYPE: String.

Number of hash partitions when the index is partitioned by quantity. DATATYPE: Integer.

Tablespaces where the index hash partitions should be stored. DATATYPE: String.

Determines whether the indexes scope is global or local. DATATYPE: Boolean.

Returns an OracleIndexPartition object specified by the given Number or GUID. PARAMETERS: Identifier (Integer or String).

Type of index partition used to partition the index for Oracle 10 and later versions. DATATYPE: String.
  • No labels