public class LOBDescriptor extends AbstractChildDBObject
create table RANGE_LIST1 ( C1 number , C2 number , C_CLOB clob , C_BLOB blob , C_VARRAY T_VARRAY ) partition by range(C1) subpartition by list(C2) subpartition template ( subpartition RANGE_LIST1_SP1 lob(C_CLOB) store as RANGE_LIST1_SP1_SEG1(tablespace EXAMPLE) ) ( partition P100 less than(100) lob(C_BLOB, C_CLOB) store as (cache reads nologging) lob(C_VARRAY) store as RANGE_LIST1_P100_SEG1(storage(freelist groups 5) nocache) ( subpartition RANGE_LIST1_P100_SP1 lob(C_CLOB) store as RANGE_LIST1_P100_SP1_SEG1(tablespace USERS) ,subpartition RANGE_LIST1_P100_SP2 varray C_VARRAY store as RANGE_LIST1_P100_SP2_SEG1 ) )
A LOBDescriptor defines :
In the following DDL clauses properties STORAGE_ENABLED_IN_ROW to STORAGE
are designated LOB_PARAMETERS.
DDL clauses for LOB and VARRAY columns of a range or list partition
Modifier and Type | Class and Description |
---|---|
static class |
LOBDescriptor.LOBCache |
AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
LOB_PARAMETER_CACHE |
static java.lang.String |
LOB_PARAMETER_CACHEREADS |
static java.lang.String |
LOB_PARAMETER_NOCACHE |
static java.lang.String |
TYPE |
Constructor and Description |
---|
LOBDescriptor() |
Modifier and Type | Method and Description |
---|---|
void |
addColumn(DBObjectID column)
Add a column to the column list.
|
java.lang.String |
getCache()
Deprecated.
- Use
getLOBCache() |
java.lang.Integer |
getChunk()
Return the value of CHUNK.
|
DBObjectID[] |
getColumns() |
java.lang.Integer |
getFreepools()
Return the value of FREEPOOLS
|
LOBDescriptor.LOBCache |
getLOBCache()
Gets the LOB cache value (can be
null ). |
java.lang.String |
getLOBSegName()
Gets the segment name for this LOB.
|
java.lang.String |
getName()
Retrieves the name of this object.
|
java.lang.Integer |
getPctVersion()
Return the value of PCTVERSION.
|
OracleStorageProperties |
getStorage() |
java.lang.String |
getType()
Returns the type of this object.
|
static boolean |
isLOBColumn(Column column)
Tests whether the given Column's datatype is a LOB type.
|
static boolean |
isLOBColumn(DBObjectID colID)
Deprecated.
use isLOBColumn(DBObjectID,DBObject) - resolving IDs is
unnecessary.
|
static boolean |
isLOBColumn(DBObjectID colID,
DBObject context)
Tests whether the datatype for the Column with the given ID is a LOB
type.
|
static boolean |
isLOBType(DataType type)
Checks whether the given DataType is a LOB type, and can therefore have
LOB properties defined.
|
boolean |
isRetention() |
boolean |
isStorageEnabledInRow() |
static boolean |
isVARRAYColumn(Column column)
Tests whether the given Column's datatype is a VARRAY type.
|
static boolean |
isVARRAYColumn(DBObjectID colID)
Deprecated.
use isVARRAYColumn(DBObjectID,DBObject) - resolving IDs is
unnecessary.
|
static boolean |
isVARRAYColumn(DBObjectID colID,
DBObject context)
Tests whether the datatype for the Column with the given ID is a VARRAY
type.
|
static boolean |
isVARRAYType(DataType type)
Tests whether the given DataType is a VARRAY Type.
|
void |
removeColumn(DBObjectID column)
Remove a column from the column list.
|
void |
setCache(java.lang.String cache)
Deprecated.
|
void |
setChunk(java.lang.Integer chunk)
Set the value of CHUNK.
|
void |
setColumns(DBObjectID[] columns)
Replace the column list.
|
void |
setFreepools(java.lang.Integer freepools)
Set the value of FREEPOOLS.
|
void |
setLOBCache(LOBDescriptor.LOBCache cache)
Sets the LOB cache value.
|
void |
setLOBSegName(java.lang.String name)
Sets the name of the segment for this LOB.
|
void |
setPctVersion(java.lang.Integer pctVersion)
Set the value of PCTVERSION.
|
void |
setRetention(boolean retention) |
void |
setStorage(OracleStorageProperties storage) |
void |
setStorageEnabledInRow(boolean storageEnabledInRow) |
setParent
addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, copyToImpl, equals, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, findOwnedObject, findParent, fireObjectUpdated, firePropertyChanged, getChildSupport, getID, getOwnedObjects, getOwnedObjects, getOwnedObjectsImpl, getParent, getProperties, getProperty, getProperty, getReferenceIDs, getReferenceIDsImpl, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, removeThisAsParent, replaceReferenceIDs, setID, setName, setProperties, setProperty, toString
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
getParent
addObjectListener, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, getID, getOwnedObjects, getOwnedObjects, getProperties, getReferenceIDs, hashCode, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName
getProperty, getProperty, setProperties, setProperty
public static final java.lang.String TYPE
public static final java.lang.String LOB_PARAMETER_CACHE
public static final java.lang.String LOB_PARAMETER_NOCACHE
public static final java.lang.String LOB_PARAMETER_CACHEREADS
public java.lang.String getName()
DBObject
getName
in interface DBObject
getName
in class AbstractDBObject
public java.lang.String getType()
DBObject
public void setLOBSegName(java.lang.String name)
name
- the internal name for the LOB segmentpublic java.lang.String getLOBSegName()
public void setColumns(DBObjectID[] columns)
columns
- public DBObjectID[] getColumns()
public void addColumn(DBObjectID column)
column
- public void removeColumn(DBObjectID column)
column
- public void setChunk(java.lang.Integer chunk)
chunk
- : null or an integer between 1 and min( next_extent, 32768 ).public java.lang.Integer getChunk()
public void setPctVersion(java.lang.Integer pctVersion)
pctVersion
- : null or an integer between 0 and 100public java.lang.Integer getPctVersion()
public void setFreepools(java.lang.Integer freepools)
freepools
- : null or a positive integerpublic java.lang.Integer getFreepools()
public void setStorage(OracleStorageProperties storage)
public OracleStorageProperties getStorage()
public void setRetention(boolean retention)
public boolean isRetention()
public void setStorageEnabledInRow(boolean storageEnabledInRow)
public boolean isStorageEnabledInRow()
@Deprecated public void setCache(java.lang.String cache)
setLOBCache(oracle.javatools.db.ora.LOBDescriptor.LOBCache)
@Deprecated public java.lang.String getCache()
getLOBCache()
public void setLOBCache(LOBDescriptor.LOBCache cache)
null
,
LOBCache.CACHE
, LOBCache.CACHE
or
LOBCache.CACHE_READS
public LOBDescriptor.LOBCache getLOBCache()
null
).@Deprecated public static boolean isLOBColumn(DBObjectID colID)
isLOBColumn(DBObjectID,DBObject)
public static boolean isLOBColumn(DBObjectID colID, DBObject context)
the
- id of the column to testcontext
- the context object for the search, this must be a child
of the same Table that the Column is on for the lookup to work.isLOBColumn(Column)
public static boolean isLOBColumn(Column column)
isLOBType(oracle.javatools.db.datatypes.DataType)
directly if you already have the DataType.the
- column to testisLOBType(oracle.javatools.db.datatypes.DataType)
public static boolean isLOBType(DataType type)
type
- the type to test@Deprecated public static boolean isVARRAYColumn(DBObjectID colID)
isVARRAYColumn(DBObjectID,DBObject)
public static boolean isVARRAYColumn(DBObjectID colID, DBObject context)
the
- id of the column to testcontext
- the context object for the search, this must be a child
of the same Table that the Column is on for the lookup to work.isVARRAYColumn(Column)
public static boolean isVARRAYColumn(Column column)
isVARRAYType(oracle.javatools.db.datatypes.DataType)
directly if you already have the DataType.the
- column to testisVARRAYType(oracle.javatools.db.datatypes.DataType)
public static boolean isVARRAYType(DataType type)
type
- the type to test