You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 2
Next »
Public Methods
| Method | Description |
|---|
| Add a new OracleTablePartition object. PARAMETERS: HighValues (String). |
| Add a column to the partition key. For type LIST, the passed-in column replaces the previous column. PARAMETERS: Name (String). |
| Add a column to the subpartition key. For type LIST, the passed-in column replaces the previous column. PARAMETERS: Name (String). |
| Delete a column from the partition key. You cannot delete the last column in the key. PARAMETERS: Name (String). |
| Delete a column from the subpartition key. You cannot delete the last column in the key. PARAMETERS: Name (String). |
| Delete all columns in the partition key. This also deletes all partitions and all subpartitions and the subpartition key. |
| Delete all columns in the subpartition key. This also deletes all subpartitions. |
| 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). |
| 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). |
| Returns the collection of Oracle table level subpartitions of the parent table. |
| Remove the OracleTablePartition specified by the given Number. PARAMETERS: Number (Integer). |
| Remove the OracleTablePartition 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: Name of the partition column (String), Number (Integer). |
| Change the partition type. Pass in a string containing RANGE, LIST, HASH, or COMPOSITE. PARAMETERS: Type (String), ColumnName (String). |
| 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). |
| 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). |
Public Properties
| Property | Description |
|---|
| Returns a OracleTablePartition object specified by the given Number or GUID. PARAMETERS: Identifier (Integer or String). |
|
|
| Number of OracleTablePartition objects in the collection. DATATYPE: Integer. |
| Names of the columns in the PartitionKey as a comma-separated list in sequence order. DATATYPE: String. |
| Type of partition: RANGE, HASH, LIST, or COMPOSITE. DATATYPE: String. |
| Names of the columns in the Subpartition Key as a comma-separated list in sequence order. DATATYPE: String. |
| Type of subpartition: HASH, LIST, or NONE, if the partition type is not COMPOSITE. DATATYPE: String. |
| For HASH partitions only. Quantity of partitions. Use when not wanting to name individual partitions. Positive integers only. Delete any named partitions first. DATATYPE: String. |
| For HASH partitions only. Comma-separated list of tablespaces for un-named partitions. DATATYPE: String. |
| OracleTablePartition object specified by the given Number or GUID. PARAMETERS: Identifier (Integer or String). |
| Set/unset the Oracle Range Partition Interval property. It can be set only if the partition type is Range. |
| Set/unset the Oracle Reference Partition Foreign Key property. It can be set only if the partition type is Reference. |
| Number of subpartitions. This does not include subpartitions specified under each partition. DATATYPE: Integer. |