Public Methods

MethodDescription
AddAdd a new OracleTablePartition object. PARAMETERS: HighValues (String).
AddColumnToPartitionKeyAdd a column to the partition key. For type LIST, the passed-in column replaces the previous column. PARAMETERS: Name (String).
AddColumnToSubpartitionKeyAdd a column to the subpartition key. For type LIST, the passed-in column replaces the previous column. PARAMETERS: Name (String).
DeleteColumnFromPartitionKeyDelete a column from the partition key. You cannot delete the last column in the key. PARAMETERS: Name (String).
DeleteColumnFromSubpartitionKeyDelete a column from the subpartition key. You cannot delete the last column in the key. PARAMETERS: Name (String).
DeletePartitionKeyDelete all columns in the partition key. This also deletes all partitions and all subpartitions and the subpartition key.
DeleteSubpartitionKeyDelete all columns in the subpartition key. This also deletes all subpartitions.
GetPartitionColumnNumberLooks 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).
GetSubpartitionColumnNumberLooks 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). 
OracleTableSubpartitionsReturns the collection of Oracle table level subpartitions of the parent table.
RemoveRemove the OracleTablePartition specified by the given Number. PARAMETERS: Number (Integer).
RemoveByNameRemove the OracleTablePartition 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: Name of the partition column (String), Number (Integer).
SetPartitionTypeChange the partition type. Pass in a string containing RANGE, LIST, HASH, or COMPOSITE. PARAMETERS: Type (String), ColumnName (String).
SetSubpartitionColumnNumberChange 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).
SetSubpartitionTypeDeletes 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

PropertyDescription
_ItemReturns a OracleTablePartition object specified by the given Number or GUID. PARAMETERS: Identifier (Integer or String).
_NewEnum
CountNumber of OracleTablePartition objects in the collection. DATATYPE: Integer.
GetPartitionKeyColumnsNames of the columns in the PartitionKey as a comma-separated list in sequence order. DATATYPE: String.
GetPartitionTypeType of partition: RANGE, HASH, LIST, or COMPOSITE. DATATYPE: String.
GetSubpartitionKeyColumnsNames of the columns in the Subpartition Key as a comma-separated list in sequence order. DATATYPE: String.
GetSubpartitionTypeType of subpartition: HASH, LIST, or NONE, if the partition type is not COMPOSITE. DATATYPE: String.
HashPartitionCountFor HASH partitions only. Quantity of partitions. Use when not wanting to name individual partitions. Positive integers only. Delete any named partitions first. DATATYPE: String.
HashPartitionTablespacesFor HASH partitions only. Comma-separated list of tablespaces for un-named partitions. DATATYPE: String.
ItemOracleTablePartition object specified by the given Number or GUID. PARAMETERS: Identifier (Integer or String).
RangePartitionIntervalSet/unset the Oracle Range Partition Interval property. It can be set only if the partition type is Range.
ReferencePartitionForeignKeySet/unset the Oracle Reference Partition Foreign Key property. It can be set only if the partition type is Reference.
SubpartitionCountNumber of subpartitions. This does not include subpartitions specified under each partition. DATATYPE: Integer.