public class TablePartition extends AbstractChildDBObject
The following DDL describes 3 partitions (P100, P500, PMAX), 2 partition level subpartitions (RANGE_HASH2_SP3, RANGE_HASH2_SP4), and 2 subpartition templates (RANGE_HASH2_SP1, RANGE_HASH2_SP2).
create table RANGE_HASH2 ( C1 number , C2 number ) partition by range(C1) subpartition by hash(C2) subpartition template ( subpartition RANGE_HASH2_SP1 ,subpartition RANGE_HASH2_SP2 ) ( partition P100 values less than(100) ( subpartition RANGE_HASH2_SP3 ,subpartition RANGE_HASH2_SP4 ) ,partition P500 values less than(500) ,partition PMAX values less than(maxvalue) )
Each partition, partition level subpartition, and subpartition template is represented by a TablePartition object. A TablePartition defines
DDL clauses when OBJECT_TYPE = PARTITION and PARTITION_TYPE = HASH
OracleTablePartitions
,
LOBDescriptor
Modifier and Type | Class and Description |
---|---|
static class |
TablePartition.ListValue |
static class |
TablePartition.RangeValue |
AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
COMPRESS |
static java.lang.String |
NOCOMPRESS |
static java.lang.String |
TYPE |
Constructor and Description |
---|
TablePartition() |
TablePartition(OracleTablePartitions.PartitionType partitionType,
OracleTablePartitions.ObjectType objectType) |
TablePartition(java.lang.String name) |
TablePartition(java.lang.String name,
OracleTablePartitions.PartitionType partitionType,
OracleTablePartitions.ObjectType objectType) |
Modifier and Type | Method and Description |
---|---|
void |
addLOBDescriptor(LOBDescriptor lobDescriptor)
Add a LOBDescriptor object that defines the (sub)partitioning properties
of a LOB or VARRAY column for this (sub)partition.
|
void |
addValue(java.lang.Object value)
Add a value to the ordered list of values that define a range partition or
list (sub)partition.
|
void |
addValue(java.lang.Object value,
int atIndex)
Add a value to the ordered list of values that define a range partition or
list (sub)partition.
|
java.lang.String |
getCompression()
Deprecated.
Compression is now stored in an OracleTableProperties object in
the TablePartition property map, keyed by OracleTableProperties.KEY
|
LOBDescriptor[] |
getLOBDescriptors()
Return an array of LOBDescriptor objects that define the (sub)partitioning
properties of a table's LOB or VARRAY columns for this (sub)partition.
|
OracleTablePartitions.ObjectType |
getObjectType() |
OracleTablePartitions |
getPartitionLevelSubpartitions()
Get the OracleTablePartitions object that represents the partition level
subpartitions of a composite range partition or range subpartition template.
|
OracleTablePartitions.PartitionType |
getPartitionType() |
OracleStorageProperties |
getSegmentAttributes() |
java.lang.String |
getType()
Returns the type of this object.
|
java.lang.Object[] |
getValues()
Return an array of values that define a range partition or list
(sub)partition.
|
void |
removeAllLOBDescriptors()
Remove all LOBDescriptor objects that define the (sub)partitioning properties
of a table's LOB or VARRAY columns for this (sub)partition.
|
void |
removeLOBDescriptor(LOBDescriptor lobDescriptor)
Remove a LOBDescriptor object that defines the (sub)partitioning properties
of a LOB or VARRAY column for this (sub)partition.
|
void |
removeValue(java.lang.Object value)
Remove a value from the ordered list of values that define a range partition
or list (sub)partition.
|
void |
setCompression(java.lang.String compression)
Deprecated.
Compression is now stored in an OracleTableProperties object in
the TablePartition property map, keyed by OracleTableProperties.KEY
|
void |
setLOBDescriptors(LOBDescriptor[] lobDescriptors)
Replace the LOBDescriptor objects that define the (sub)partitioning properties
of a table's LOB and VARRAY columns for this (sub)partition.
|
void |
setName(java.lang.String name)
Set the NAME of the (sub)partition.
|
void |
setObjectType(OracleTablePartitions.ObjectType objectType)
Set OBJECT_TYPE as one of
PARTITION, SUBPARTITION_TEMPLATE, PARTITION_LEVEL_SUBPARTITION.
|
void |
setPartitionLevelSubpartitions(OracleTablePartitions partitionLevelSubpartitions)
Set the OracleTablePartitions object that represents the partition level
subpartitions of a composite range partition or range subpartition template.
|
void |
setPartitionType(OracleTablePartitions.PartitionType partitionType)
Set PARTITION_TYPE as one of RANGE, HASH, LIST.
|
void |
setSegmentAttributes(OracleStorageProperties segmentAttributes)
Set the OracleStorageProperties object defining the (sub)partition segment
attribute properties.
|
void |
setValues(java.lang.Object[] values)
Replace the ordered list of values that define a range partition or list
(sub)partition.
|
void |
setValues(java.lang.String values)
Replace the ordered list of values that define a range partition or list
(sub)partition with the values extracted from a comma separated list.
|
static java.util.List<java.lang.String> |
splitValues(java.lang.String string)
Returns an ordered list of values extracted from a comma separated string
ignoring commas within single and double quotes and round brackets () .
|
java.lang.String |
toString() |
setParent
addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, copyToImpl, equals, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, findOwnedObject, findParent, fireObjectUpdated, firePropertyChanged, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getOwnedObjectsImpl, getParent, getProperties, getProperty, getProperty, getReferenceIDs, getReferenceIDsImpl, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, removeThisAsParent, replaceReferenceIDs, setID, setProperties, setProperty
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
getParent
addObjectListener, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getProperties, getReferenceIDs, hashCode, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID
getProperty, getProperty, setProperties, setProperty
public static final java.lang.String TYPE
public static final java.lang.String COMPRESS
public static final java.lang.String NOCOMPRESS
public TablePartition()
public TablePartition(java.lang.String name)
public TablePartition(OracleTablePartitions.PartitionType partitionType, OracleTablePartitions.ObjectType objectType)
public TablePartition(java.lang.String name, OracleTablePartitions.PartitionType partitionType, OracleTablePartitions.ObjectType objectType)
public java.lang.String getType()
DBObject
public void setPartitionType(OracleTablePartitions.PartitionType partitionType)
partitionType
- public OracleTablePartitions.PartitionType getPartitionType()
public void setObjectType(OracleTablePartitions.ObjectType objectType)
objectType
- public OracleTablePartitions.ObjectType getObjectType()
public void setName(java.lang.String name)
setName
in interface DBObject
setName
in class AbstractDBObject
name
- public void setSegmentAttributes(OracleStorageProperties segmentAttributes)
segmentAttributes
- public OracleStorageProperties getSegmentAttributes()
@Deprecated public void setCompression(java.lang.String compression)
compression
- @Deprecated public java.lang.String getCompression()
public void setLOBDescriptors(LOBDescriptor[] lobDescriptors)
lobDescriptors
- public void addLOBDescriptor(LOBDescriptor lobDescriptor)
lobDescriptor
- public void removeLOBDescriptor(LOBDescriptor lobDescriptor)
lobDescriptor
- public void removeAllLOBDescriptors()
public LOBDescriptor[] getLOBDescriptors()
public void setValues(java.lang.Object[] values)
values
- public void setValues(java.lang.String values)
values
- : Comma separated list of valuespublic java.lang.Object[] getValues()
public void addValue(java.lang.Object value)
value
- public void addValue(java.lang.Object value, int atIndex)
value
- public void removeValue(java.lang.Object value)
value
- public void setPartitionLevelSubpartitions(OracleTablePartitions partitionLevelSubpartitions)
partitionLevelSubpartitions
- public OracleTablePartitions getPartitionLevelSubpartitions()
public java.lang.String toString()
toString
in class AbstractDBObject
public static java.util.List<java.lang.String> splitValues(java.lang.String string)
string
-