Page History
Public Methods
Method | Description |
---|---|
Add | Add a new OracleIndexPartition object. PARAMETERS: HighValues (String). |
AddColumnToPartitionKey | Add another column to the partition key. For type LIST, the passed in column replaces the previous column. PARAMETERS: Name (String). |
DeleteColumnFromPartitionKey | Delete a column from the partition key. Cannot delete last column in key. PARAMETERS: Name (String). |
DeletePartitionKey | Delete all columns in the partition key. This |
...
also deletes all partitions and all subpartitions and the subpartition key. | |
GetPartitionColumnNumber | 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 | Remove a OracleIndexPartition specified by the given Number. PARAMETERS: Number (Integer). |
RemoveByName | Remove the OracleIndexPartition specified by the given Name. PARAMETERS: Name (String). |
SetPartitionColumnNumber | 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
Property | Description |
---|---|
_Item | Returns an OracleIndexPartition object specified by the given Number or GUID. PARAMETERS: Identifier (Integer or String). |
_NewEnum | |
Count | Number of OracleIndexPartition objects in the collection. DATATYPE: Integer. |
GetPartitionKeyColumns | Names of the columns in the PartitionKey as a comma-separated list in sequence order. DATATYPE: String. |
HashPartitionCount | Number of hash partitions when the index is partitioned by quantity. DATATYPE: Integer. |
HashPartitionTablespaces | Tablespaces where the index hash partitions should be stored. DATATYPE: String. |
IsGlobal | Determines whether the indexes scope is global or local. DATATYPE: Boolean. |
Item | Returns an OracleIndexPartition object specified by the given Number or GUID. PARAMETERS: Identifier (Integer or String). |
PartitionType | Type of index partition used to partition the index for Oracle 10 and later versions. DATATYPE: String. |
Info | ||
---|---|---|
| ||