Versions Compared

Key

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

Public Methods

MethodDescription

Add a new OracleIndexPartition object. PARAMETERS: HighValues (String).

Add another column to the partition key. For type LIST, the passed in column replaces the previous column. PARAMETERS: Name (String).

Delete a column from the partition key. Cannot delete last column in key. PARAMETERS: Name (String).

Delete all columns in the partition key. This

...

also deletes all partitions and all subpartitions and the subpartition key.

Looks for the column in the partition key. If found, it returns the column's number. PARAMETERS: Partition Column Name (String). RETURN DATATYPE: Integer.

Remove a OracleIndexPartition specified by the given Number. PARAMETERS: Number (Integer).

Remove the OracleIndexPartition specified by the given Name. PARAMETERS: Name (String).

Change 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.
Info
titleSee Also