Versions Compared

Old Version 2

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 3

changes.mady.by.user Nadja Pollard

Saved on

Key

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

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

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