Method | Description |
---|
Add | Add a new OracleTablePartition object. PARAMETERS: HighValues (String). |
AddColumnToPartitionKey | Add a column to the partition key. For type LIST, the passed-in column replaces the previous column. PARAMETERS: Name (String). |
AddColumnToSubpartitionKey | Add a column to the subpartition key. For type LIST, the passed-in column replaces the previous column. PARAMETERS: Name (String). |
DeleteColumnFromPartitionKey | Delete a column from the partition key. You cannot delete the last column in the key. PARAMETERS: Name (String). |
DeleteColumnFromSubpartitionKey | Delete a column from the subpartition key. You cannot delete the last column in the key. PARAMETERS: Name (String). |
DeletePartitionKey | Delete all columns in the partition key. This also deletes all partitions and all subpartitions and the subpartition key. |
DeleteSubpartitionKey | Delete all columns in the subpartition key. This also deletes all subpartitions. |
GetPartitionColumnNumber | Looks for the column in the partition key. If found, it returns the column's number. RETURN DATATYPE: Integer. PARAMETERS: Name of the partition column (String). |
GetSubpartitionColumnNumber | Looks for the column in the subpartition key. If found, it returns the column's number. If not, it returns zero. RETURN DATATYPE: Integer. PARAMETERS: Name of the subpartition column (String). |
OracleTableSubpartitions | Returns the collection of Oracle table level subpartitions of the parent table. |
Remove | Remove the OracleTablePartition specified by the given Number. PARAMETERS: Number (Integer). |
RemoveByName | Remove the OracleTablePartition 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: Name of the partition column (String), Number (Integer). |
SetPartitionType | Change the partition type. Pass in a string containing RANGE, LIST, HASH, or COMPOSITE. PARAMETERS: Type (String), ColumnName (String). |
SetSubpartitionColumnNumber | Change the sequence of the columns in the subpartition key by setting the number of a column. PARAMETERS: Name of the subpartition column (String), Number (Integer). |
SetSubpartitionType | Deletes all subpartitions and SubpartitionKey. Passed in name is new Key. Changes SubpartitionType if PartitionType is COMPOSITE. Pass in LIST or HASH. PARAMETERS: Type and ColumnName (String). |