public class MaterializedView extends Table implements SQLQueryOwner
Modifier and Type | Class and Description |
---|---|
static class |
MaterializedView.BuildType |
static class |
MaterializedView.FastRefreshable |
static class |
MaterializedView.PrebuiltType
Indicates whether the materialized view is prebuilt including whether it is specified with or without precision.
|
static class |
MaterializedView.RefreshMethod
Method used to refresh the Materialized View.
|
static class |
MaterializedView.RefreshMode
Different modes that can be selected for how the Materialized View will be refreshed.
|
static class |
MaterializedView.RefreshWith |
static class |
MaterializedView.RewriteCapability
Valid values for the rewrite capability.
|
static class |
MaterializedView.RollbackSegmentType |
static class |
MaterializedView.Staleness
Relationship between the contents of the materialized view and the contents of the materialized view's masters
|
static class |
MaterializedView.UsingConstraints
Wether this view can using trusted constraints as well as those that are enforced.
|
Table.TableType
AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
TYPE |
TABLE_TYPE_KEY
Constructor and Description |
---|
MaterializedView() |
MaterializedView(java.lang.String name, Schema schema) |
Modifier and Type | Method and Description |
---|---|
MaterializedView.BuildType |
getBuildType()
Gets the type specified in the build clause
|
java.lang.Boolean |
getCache()
Gets that the blocks retrieved for this materialized view are placed at the most recently used end of the least recently used (LRU) list in the buffer cache when a full scan is performed.
|
Column[] |
getColumns()
Retrieves the list of columns contained in this relation.
|
java.lang.Boolean |
getCompression()
Gets the compress property for this materialized view's table.
|
MaterializedView.FastRefreshable |
getFastRefresh()
Gets whether the materialized view is eligible for incremental (fast) refresh.
|
java.lang.String |
getFirstRefresh()
Gets the String representing the Datetime expression used in the Start With option of the REFRESH clause
|
int |
getIndexInitTrans()
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
int |
getIndexMaxExtent()
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
int |
getIndexMinExtent()
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
int |
getIndexPercentFree()
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
int |
getIndexPercentUsed()
Deprecated.
You cannot specify the Percent Used for an Index. This method has been deprecated
|
int |
getInitExtent()
Deprecated.
Storage properties of the Materialized View are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.KEY
|
java.lang.String |
getInterval()
A datetime expression for calculating the interval between automatic refreshes.
|
MaterializedView.RefreshWith |
getKeyType()
The key type.
|
java.util.Date |
getLastRefreshDate()
Gets the date on which the materialized view was most recently refreshed.
|
MaterializedView.RefreshMethod |
getLastRefreshType()
Gets the method used for the most recent refresh
|
java.lang.String[] |
getMasters()
Deprecated.
|
int |
getMaxTrans()
Deprecated.
Storage properties of the Materialized View are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.KEY
|
int |
getMinTrans()
Deprecated.
Storage properties of the Materialized View are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.KEY
|
int |
getNextExtent()
Deprecated.
Storage properties of the Materialized View are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.KEY
|
java.lang.String |
getNextRefresh()
Deprecated.
use getNextRefreshDate()
|
java.util.Date |
getNextRefreshDate()
Gets the date on which the materialized view will next be refreshed.
|
MaterializedView.PrebuiltType |
getOnPrebuilt()
Gets whether this materialized view is prebuilt.
|
int |
getParallel()
Deprecated.
- use
getParallelDegree() |
java.lang.Integer |
getParallelDegree()
Get the degree of parallelism (the number of parallel threads used in the parallel operation) where : 0 = PARALLEL DEFAULT (Oracle server selects the degree) 1 = NOPARALLEL (default) n = PARALLEL n
|
MaterializedView.RefreshMethod |
getRefreshMethod()
Gets the default method used to refresh the materialized view
|
MaterializedView.RefreshMode |
getRefreshMode()
Gets the refresh mode of the materialized view.
|
MaterializedView.RewriteCapability |
getRewriteType()
Gets the rewrite type for this view.
|
java.lang.String |
getRollbackSegmentName()
The rollback segment name - ignored if the the rollback segment type is null or set to RS_NONE.
|
MaterializedView.RollbackSegmentType |
getRollbackSegmentType()
If specifying a rollback segment in the refresh clause of the materialized view, returns whether the rollback segment is local or master:
|
SQLQuery |
getSQLQuery()
Returns the query that defines the view as a SQLQuery object.
|
MaterializedView.Staleness |
getStaleness()
Gets the relationship between the contents of the materialized view and the contents of the materialized view's masters
|
java.lang.String |
getTablespace()
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
java.lang.String |
getType()
Returns the type of this object.
|
MaterializedView.UsingConstraints |
getUsingConstraints()
Returns whether or not the materialized view can used TRUSTED constraints as well as just ENFORCED constraints (the default).
|
java.lang.String |
getViewText()
Convinience method that returns the view's query in text format.
|
java.lang.Boolean |
isCache()
Deprecated.
use getCache() instead
|
boolean |
isDeclarative()
Convinience method to check whether this mat view has a declarative query.
|
boolean |
isRewrite()
Gets whether rewrite is enabled for this view.
|
boolean |
isUpdatable()
Gets whether the view is updatable.
|
boolean |
isUseNoIndex()
Gets whether the materialized view was created using the USING NO INDEX clause or the materialized view was created with the default index.
|
void |
setBuildType(MaterializedView.BuildType buildType)
Sets the type specified in the build clause
|
void |
setCache(java.lang.Boolean cache)
Sets that the blocks retrieved for this materialized view are placed at the most recently used end of the least recently used (LRU) list in the buffer cache when a full scan is performed.
|
void |
setCompression(java.lang.Boolean compression)
Sets the compress property for this materialized view's table.
|
void |
setFastRefresh(MaterializedView.FastRefreshable fastRefresh)
Sets whether the materialized view is eligible for incremental (fast) refresh.
|
void |
setFirstRefresh(java.lang.String firstRefresh)
Sets the String representing the Datetime expression used in the Start With option of the REFRESH clause
|
void |
setIndexInitTrans(int indexInitTrans)
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
void |
setIndexMaxExtent(int indexMaxExtent)
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
void |
setIndexMinExtent(int indexMinExtent)
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
void |
setIndexPercentFree(int indexPctFree)
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
void |
setIndexPercentUsed(int indexPctUsed)
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
void |
setInitExtent(int initExtent)
Deprecated.
Storage properties of the Materialized View are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.KEY
|
void |
setInterval(java.lang.String interval)
A datetime expression for calculating the interval between automatic refreshes.
|
void |
setKeyType(MaterializedView.RefreshWith keyType)
The key type.
|
void |
setLastRefreshDate(java.util.Date lastRefreshDate)
Sets the date on which the materialized view was most recently refreshed.
|
void |
setLastRefreshType(MaterializedView.RefreshMethod lastRefreshType)
Sets the method used for the most recent refresh
|
void |
setMasters(java.lang.String[] masters)
Deprecated.
|
void |
setMaxTrans(int maxTrans)
Deprecated.
Storage properties of the Materialized View are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.KEY
|
void |
setMinTrans(int minTrans)
Deprecated.
Storage properties of the Materialized View are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.KEY
|
void |
setNextExtent(int nextExtent)
Deprecated.
Storage properties of the Materialized View are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.KEY
|
void |
setNextRefresh(java.lang.String nextStr)
Deprecated.
use setNextRefreshDate()
|
void |
setNextRefreshDate(java.util.Date nextRefreshDate)
Sets the date on which the materialized view will next be refreshed.
|
void |
setOnPrebuilt(MaterializedView.PrebuiltType onPrebuilt)
Sets whether this materialized view is prebuilt.
|
void |
setParallel(int parallel)
Deprecated.
|
void |
setParallelDegree(java.lang.Integer parallel)
Set the degree of parallelism (the number of parallel threads used in the parallel operation) where : 0 = PARALLEL DEFAULT (Oracle server selects the degree) 1 = NOPARALLEL (default) n = PARALLEL n
|
void |
setRefreshMethod(MaterializedView.RefreshMethod refreshMethod)
Sets the default method used to refresh the materialized view
|
void |
setRefreshMode(MaterializedView.RefreshMode refreshMode)
Sets the refresh mode of the materialized view.
|
void |
setRewrite(boolean rewrite)
Sets whether rewrite is enabled for this view.
|
void |
setRewriteType(MaterializedView.RewriteCapability rewriteType)
Sets the rewrite type for this view.
|
void |
setRollbackSegmentName(java.lang.String rollbackSegmentName)
Sets the rollback segment name - ignored if the the rollback segment type is null or set to RS_NONE.
|
void |
setRollbackSegmentType(MaterializedView.RollbackSegmentType rollbackSegmentType)
If specifying a rollback segment in the refresh clause of the materialized view, specifies whether the rollback segment is local or master:
|
void |
setSQLQuery(SQLQuery query)
Sets the query that defines the view.
|
void |
setStaleness(MaterializedView.Staleness staleness)
Sets the relationship between the contents of the materialized view and the contents of the materialized view's masters
|
void |
setTablespace(java.lang.String tablespace)
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
void |
setUpdatable(boolean updatable)
Sets whether the view is updateable.
|
void |
setUseNoIndex(boolean useNoIndex)
Sets whether the materialized view was created using the USING NO INDEX clause or the materialized view was created with the default index.
|
void |
setUsingConstraints(MaterializedView.UsingConstraints usingConstraints)
Specifies whether or not the materialized view can use TRUSTED constraints as well as just ENFORCED constraints (the default).
|
addIndex, getIndex, getIndexes, removeIndex, setIndexes, setSchema
addColumn, addColumn, addConstraint, getColumn, getConstraint, getConstraints, getOwnedObjectsImpl, removeColumn, removeConstraint, setColumns, setConstraints
getSchema
fireObjectUpdated
checkInit, checkInit, copyToImpl, equalsImpl, getProperties, getReferenceIDsImpl, needsInitialization
addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, findOwnedObject, findParent, firePropertyChanged, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getParent, getProperty, getProperty, getReferenceIDs, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, removeThisAsParent, replaceReferenceIDs, setID, setName, setProperties, setProperty, toString
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
addObjectListener, copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getParent, getProperties, getReferenceIDs, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName
getProperty, getProperty, setProperties, setProperty
addObjectListener, removeObjectListener
addObjectListener, fireObjectUpdated, removeObjectListener
public static final java.lang.String TYPE
public MaterializedView()
public MaterializedView(java.lang.String name, Schema schema)
public java.lang.String getType()
DBObject
public SQLQuery getSQLQuery()
getSQLQuery
in interface SQLQueryOwner
public void setSQLQuery(SQLQuery query)
setSQLQuery
in interface SQLQueryOwner
public Column[] getColumns()
Relation
getColumns
in class Relation
public java.lang.String getViewText()
public void setUpdatable(boolean updatable)
public boolean isUpdatable()
public void setRewrite(boolean rewrite)
public boolean isRewrite()
public void setRewriteType(MaterializedView.RewriteCapability rewriteType)
MaterializedView.RewriteCapability
public MaterializedView.RewriteCapability getRewriteType()
MaterializedView.RewriteCapability
public void setRefreshMode(MaterializedView.RefreshMode refreshMode)
public MaterializedView.RefreshMode getRefreshMode()
public void setRefreshMethod(MaterializedView.RefreshMethod refreshMethod)
public MaterializedView.RefreshMethod getRefreshMethod()
public void setFastRefresh(MaterializedView.FastRefreshable fastRefresh)
public MaterializedView.FastRefreshable getFastRefresh()
public void setLastRefreshType(MaterializedView.RefreshMethod lastRefreshType)
lastRefreshType
- an int representing the resfresh typepublic MaterializedView.RefreshMethod getLastRefreshType()
public void setLastRefreshDate(java.util.Date lastRefreshDate)
public java.util.Date getLastRefreshDate()
public void setNextRefreshDate(java.util.Date nextRefreshDate)
public java.util.Date getNextRefreshDate()
@Deprecated public java.lang.String getNextRefresh()
@Deprecated public void setNextRefresh(java.lang.String nextStr)
public java.lang.String getInterval()
public void setInterval(java.lang.String interval)
interval
- a SQL expression, e.g. "NEXT_DAY(TRUNC(SYSDATE), 'MONDAY')"public java.lang.String getFirstRefresh()
public void setFirstRefresh(java.lang.String firstRefresh)
firstRefresh
-public void setStaleness(MaterializedView.Staleness staleness)
staleness
- an int representing the stalenesspublic MaterializedView.Staleness getStaleness()
public void setBuildType(MaterializedView.BuildType buildType)
buildType
- the build typepublic MaterializedView.BuildType getBuildType()
public void setOnPrebuilt(MaterializedView.PrebuiltType onPrebuilt)
public MaterializedView.PrebuiltType getOnPrebuilt()
public void setUseNoIndex(boolean useNoIndex)
public boolean isUseNoIndex()
@Deprecated public void setIndexPercentFree(int indexPctFree)
indexPctFree
-@Deprecated public int getIndexPercentFree()
@Deprecated public void setIndexPercentUsed(int indexPctUsed)
@Deprecated public int getIndexPercentUsed()
@Deprecated public void setIndexInitTrans(int indexInitTrans)
@Deprecated public int getIndexInitTrans()
@Deprecated public void setMaxTrans(int maxTrans)
@Deprecated public int getMaxTrans()
@Deprecated public void setMinTrans(int minTrans)
@Deprecated public int getMinTrans()
@Deprecated public void setInitExtent(int initExtent)
@Deprecated public int getInitExtent()
@Deprecated public void setNextExtent(int nextExtent)
@Deprecated public int getNextExtent()
@Deprecated public void setIndexMinExtent(int indexMinExtent)
indexMinExtent
-@Deprecated public int getIndexMinExtent()
@Deprecated public void setIndexMaxExtent(int indexMaxExtent)
indexMaxExtent
-@Deprecated public int getIndexMaxExtent()
@Deprecated public java.lang.String getTablespace()
@Deprecated public void setTablespace(java.lang.String tablespace)
tablespace
- a string of the tablespace namepublic void setCache(java.lang.Boolean cache)
public java.lang.Boolean getCache()
@Deprecated public java.lang.Boolean isCache()
@Deprecated public void setMasters(java.lang.String[] masters)
@Deprecated public java.lang.String[] getMasters()
public MaterializedView.RefreshWith getKeyType()
public void setKeyType(MaterializedView.RefreshWith keyType)
public MaterializedView.UsingConstraints getUsingConstraints()
public void setUsingConstraints(MaterializedView.UsingConstraints usingConstraints)
public MaterializedView.RollbackSegmentType getRollbackSegmentType()
LOCAL is the default.
public void setRollbackSegmentType(MaterializedView.RollbackSegmentType rollbackSegmentType)
rollbackSegmentType
- the rollback typeLOCAL is the default.
public java.lang.String getRollbackSegmentName()
public void setRollbackSegmentName(java.lang.String rollbackSegmentName)
rollbackSegmentName
- the rollback segment name. Set to null or empty to use the default.public boolean isDeclarative()
isDeclarative
in interface SQLQueryOwner
@Deprecated public void setParallel(int parallel)
setParallelDegree(Integer)
@Deprecated public int getParallel()
getParallelDegree()
public void setParallelDegree(java.lang.Integer parallel)
public java.lang.Integer getParallelDegree()
public void setCompression(java.lang.Boolean compression)
compression
-public java.lang.Boolean getCompression()