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

MethodsDescription
AddHashAdds a new PartitionLevel subpartition if HASHByName (HASHQuantity equal 0, no tablespaces exist. HashByName(true) removes any). TBS optional. PARAMETERS: Number (Integer>0), Name, TBS (String).
AddListAdds a new subpartition. Requires subpartition type LIST. PARAMETERS: Number (Integer), String: Name, Values, TBS, Number must be greater than zero. Tablespace can be empty.
AddTablespaceAdds new tablespace. Requires HASH by Number. No named HASH subpartitions may exist. HashByName(false) removes any that exist. PARAMETERS: Number (Integer>0), TBS (non-empty String).
RemoveRemoves a subpartition specified by the given Number. PARAMETERS: Number (Integer).

Public Properties

PropertyDescription

OracleTableSubpartition object specified by the given Number. PARAMETERS: Number (Integer).



Number of OracleTableSubpartition objects in this collection. For example, if this is the manager of a partition, then Count is the number of subpartitions specified for that partition. DATATYPE: Integer.

Returns true if named HASH subpartitions exist. Setting this to TRUE zeroes out the HASH Quantity and deletes all existing tablespaces. Setting it to FALSE deletes all existing named HASH subpartitions. DATATYPE: Boolean.

HASH subpartitions only. Default number of subpartitions or zero if not specified. Can set this only if no named HASH subpartitions exist. HashType(FALSE) removes any remaining ones. DATATYPE: Integer.

OracleTableSubpartition object specified by the given Number. PARAMETERS: Number (Integer).

Type of subpartition. Valid values are: HASH, LIST, or NONE if the partition type is not COMPOSITE. DATATYPE: String.
Info
titleSee Also