|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.7.2) E13403-10 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object
oracle.javatools.db.AbstractDBObject
oracle.javatools.db.AbstractChildDBObject
oracle.javatools.db.ora.TablePartition
public class TablePartition
TablePartition encapsulate the properties of an individual partition or subpartition. TablePartition objects are held by an OracleTablePartitions object. For an overview of the table partitioning api see OracleTablePartitions.
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
The PARTITION_TYPE and OBJECT_TYPE must be the same as the OracleTablePartitions that contains the TablePartition object. To guarantee this create a TablePartition object using OracleTablePartitions.createPartition().`
DDL clauses when OBJECT_TYPE = PARTITION and PARTITION_TYPE = HASH
DDL clauses when OBJECT_TYPE = PARTITION and PARTITION_TYPE = LIST
DDL clauses when OBJECT_TYPE = PARTITION and PARTITION_TYPE = RANGE
DDL clauses when OBJECT_TYPE = SUBPARTITION_TEMPLATE and PARTITION_TYPE = HASH
DDL clauses when OBJECT_TYPE = SUBPARTITION_TEMPLATE and PARTITION_TYPE = LIST
DDL clauses when OBJECT_TYPE = PARTITION_LEVEL_SUBPARTITION and PARTITION_TYPE = HASH
DDL clauses when OBJECT_TYPE = PARTITION_LEVEL_SUBPARTITION and PARTITION_TYPE = LIST
OracleTablePartitions
, LOBDescriptor
Nested Class Summary | |
---|---|
static class |
TablePartition.ListValue |
static class |
TablePartition.RangeValue |
Nested classes/interfaces inherited from class oracle.javatools.db.AbstractDBObject |
---|
AbstractDBObject.ChildSupport |
Field Summary | |
---|---|
static java.lang.String |
COMPRESS |
static java.lang.String |
NOCOMPRESS |
static java.lang.String |
TYPE |
Fields inherited from interface oracle.javatools.db.DBObject |
---|
COMMENT |
Constructor Summary | |
---|---|
TablePartition() |
|
TablePartition(OracleTablePartitions.PartitionType partitionType, OracleTablePartitions.ObjectType objectType) |
|
TablePartition(java.lang.String name) |
|
TablePartition(java.lang.String name, OracleTablePartitions.PartitionType partitionType, OracleTablePartitions.ObjectType objectType) |
Method Summary | |
---|---|
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() Return the key (index-organized tables) or data segment compression of a RANGE or LIST PARTITION. |
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. |
int |
hashCode() |
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) Set the key (index-organized tables) or data segment compression. |
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() |
Methods inherited from class oracle.javatools.db.AbstractChildDBObject |
---|
copyToImpl, findParent, getParent, getProperty, setParent, setProperty |
Methods inherited from class oracle.javatools.db.AbstractDBObject |
---|
changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getOwnedObjectsImpl, getProperties, getProperty, getReferenceIDs, getReferenceIDsImpl, includeOwnedObject, includesType, includesType, removeThisAsParent, replaceReferenceIDs, setID, setProperties |
Methods inherited from class java.lang.Object |
---|
clone, finalize, getClass, notify, notifyAll, wait, wait, wait |
Methods inherited from interface oracle.javatools.db.DBObject |
---|
copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getReferenceIDs, replaceReferenceIDs, setID |
Methods inherited from interface oracle.javatools.util.DynamicPropertySet |
---|
getProperties, getProperty, setProperties |
Field Detail |
---|
public static final java.lang.String TYPE
public static final java.lang.String COMPRESS
public static final java.lang.String NOCOMPRESS
Constructor Detail |
---|
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)
Method Detail |
---|
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()
public void setCompression(java.lang.String compression)
compression
-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 int hashCode()
hashCode
in class AbstractDBObject
public static java.util.List<java.lang.String> splitValues(java.lang.String string)
string
-
|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.7.2) E13403-10 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |