OracleTableSubpartitions Collection Members

Public Methods

Methods	Description
AddHash	Adds 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).
AddList	Adds a new subpartition. Requires subpartition type LIST. PARAMETERS: Number (Integer), String: Name, Values, TBS, Number must be greater than zero. Tablespace can be empty.
AddTablespace	Adds 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).
Remove	Removes a subpartition specified by the given Number. PARAMETERS: Number (Integer).

Property	Description
_Item	OracleTableSubpartition object specified by the given Number. PARAMETERS: Number (Integer).
_NewEnum
Count	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.
HashByName	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.
HashQuantity	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.
Item	OracleTableSubpartition object specified by the given Number. PARAMETERS: Number (Integer).
SubpartitionType	Type of subpartition. Valid values are: HASH, LIST, or NONE if the partition type is not COMPOSITE. DATATYPE: String.