oracle.javatools.db.ora
Class MaterializedView

java.lang.Object
  oracle.javatools.db.AbstractDBObject
      oracle.javatools.db.AbstractBuildableObject
          oracle.javatools.db.AbstractSystemObject
              oracle.javatools.db.AbstractSchemaObject
                  oracle.javatools.db.Relation
                      oracle.javatools.db.Table
                          oracle.javatools.db.ora.MaterializedView

All Implemented Interfaces:

DBObject, SchemaObject, SQLQueryOwner, SystemObject, Copyable, DynamicPropertySet

public class MaterializedView
extends Table
implements SQLQueryOwner

A MaterializedView represents a Materialized View in the database. A Materialized View is a database object that contains the result of a query. Unlike a normal view, the data in the view is queried once and then cached. The data is refreshed at specific times.

Since:

9.0.5

Nested Class Summary

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.

Nested classes/interfaces inherited from class oracle.javatools.db.Table

Table.TableType

Nested classes/interfaces inherited from class oracle.javatools.db.AbstractDBObject

AbstractDBObject.ChildSupport

Field Summary

static java.lang.String

TYPE

Fields inherited from class oracle.javatools.db.Table

TABLE_TYPE_KEY

Fields inherited from class oracle.javatools.db.AbstractSystemObject

m_listeners

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Constructor Summary

MaterializedView()

MaterializedView(java.lang.String name, Schema schema)

Method Summary

MaterializedView.BuildType	getBuildType() Gets the type specified in the build clause
MaterializedView.FastRefreshable	getFastRefresh() Gets whether the materialized view is eligible for incremental (fast) refresh.
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()
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() 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
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.
boolean	isCache() 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.
boolean	isCompression() Gets the compress property for the Table
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(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(boolean compression) Sets the compress property for the Table
void	setFastRefresh(MaterializedView.FastRefreshable fastRefresh) Sets whether the materialized view is eligible for incremental (fast) refresh.
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)
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) 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).

Methods inherited from class oracle.javatools.db.Table

addIndex, getIndex, getIndexes, removeIndex, setIndexes, setSchema

Methods inherited from class oracle.javatools.db.Relation

addColumn, addColumn, addConstraint, getColumn, getColumns, getConstraint, getConstraints, getOwnedObjectsImpl, removeColumn, removeConstraint, setColumns, setConstraints

Methods inherited from class oracle.javatools.db.AbstractSchemaObject

addObjectListener, copyToImpl, equalsImpl, getProperty, getSchema, removeObjectListener, setProperty

Methods inherited from class oracle.javatools.db.AbstractSystemObject

addObjectListener, fireObjectUpdated, getParent, removeObjectListener

Methods inherited from class oracle.javatools.db.AbstractBuildableObject

checkInit, checkInit, getProperties, getReferenceIDsImpl, needsInitialization

Methods inherited from class oracle.javatools.db.AbstractDBObject

changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getProperty, getReferenceIDs, hashCode, includeOwnedObject, includesType, includesType, removeThisAsParent, replaceReferenceIDs, setID, setName, setProperties, toString

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, getParent, getReferenceIDs, replaceReferenceIDs, setID, setName

Methods inherited from interface oracle.javatools.util.DynamicPropertySet

getProperties, getProperty, getProperty, setProperties, setProperty

Methods inherited from interface oracle.javatools.db.SystemObject

addObjectListener, fireObjectUpdated, removeObjectListener

Field Detail

TYPE

public static final java.lang.String TYPE

See Also:

Constant Field Values

Constructor Detail

MaterializedView

public MaterializedView()

MaterializedView

public MaterializedView(java.lang.String name,
                        Schema schema)

Method Detail

getType

public java.lang.String getType()

Description copied from interface: DBObject

Returns the type of this object. Valid types include things like tables, views, synonyms, and columns.

Specified by:

getType in interface DBObject

Overrides:

getType in class Table

Returns:

a string describing the type of object.

getSQLQuery

public SQLQuery getSQLQuery()

Returns the query that defines the view as a SQLQuery object.

Specified by:

getSQLQuery in interface SQLQueryOwner

setSQLQuery

public void setSQLQuery(SQLQuery query)

Sets the query that defines the view.

Specified by:

setSQLQuery in interface SQLQueryOwner

getViewText

public java.lang.String getViewText()

Convinience method that returns the view's query in text format.

setUpdatable

public void setUpdatable(boolean updatable)

Sets whether the view is updateable.

isUpdatable

public boolean isUpdatable()

Gets whether the view is updatable.

setRewrite

public void setRewrite(boolean rewrite)

Sets whether rewrite is enabled for this view.

isRewrite

public boolean isRewrite()

Gets whether rewrite is enabled for this view.

setRewriteType

public void setRewriteType(MaterializedView.RewriteCapability rewriteType)

Sets the rewrite type for this view.

See Also:

MaterializedView.RewriteCapability

getRewriteType

public MaterializedView.RewriteCapability getRewriteType()

Gets the rewrite type for this view.

See Also:

MaterializedView.RewriteCapability

setRefreshMode

public void setRefreshMode(MaterializedView.RefreshMode refreshMode)

Sets the refresh mode of the materialized view.

getRefreshMode

public MaterializedView.RefreshMode getRefreshMode()

Gets the refresh mode of the materialized view.

setRefreshMethod

public void setRefreshMethod(MaterializedView.RefreshMethod refreshMethod)

Sets the default method used to refresh the materialized view

getRefreshMethod

public MaterializedView.RefreshMethod getRefreshMethod()

Gets the default method used to refresh the materialized view

setFastRefresh

public void setFastRefresh(MaterializedView.FastRefreshable fastRefresh)

Sets whether the materialized view is eligible for incremental (fast) refresh.

getFastRefresh

public MaterializedView.FastRefreshable getFastRefresh()

Gets whether the materialized view is eligible for incremental (fast) refresh. The Oracle Database calculates this value statically, based on the materialized view definition query:

setLastRefreshType

public void setLastRefreshType(MaterializedView.RefreshMethod lastRefreshType)

Sets the method used for the most recent refresh

Parameters:

lastRefreshType - an int representing the resfresh type

getLastRefreshType

public MaterializedView.RefreshMethod getLastRefreshType()

Gets the method used for the most recent refresh

setLastRefreshDate

public void setLastRefreshDate(java.util.Date lastRefreshDate)

Sets the date on which the materialized view was most recently refreshed. Set to null if not yet populated

getLastRefreshDate

public java.util.Date getLastRefreshDate()

Gets the date on which the materialized view was most recently refreshed. Blank if not yet populated.

setNextRefreshDate

public void setNextRefreshDate(java.util.Date nextRefreshDate)

Sets the date on which the materialized view will next be refreshed.

getNextRefreshDate

public java.util.Date getNextRefreshDate()

Gets the date on which the materialized view will next be refreshed. Blank if not yet populated.

getNextRefresh

@Deprecated
public java.lang.String getNextRefresh()

Deprecated. use getNextRefreshDate()

setNextRefresh

@Deprecated
public void setNextRefresh(java.lang.String nextStr)

Deprecated. use setNextRefreshDate()

getInterval

public java.lang.String getInterval()

A datetime expression for calculating the interval between automatic refreshes. This property is ignored unless the refresh mode is set to REFRESH_MODE_SPECIFY. If the refresh mode is REFRESH_MODE_SPECIFY and the interval is set to null, then the materialized view refreshes only once (at the time specified in getNextRefresh()). If getNextRefresh also returns null then the view is never refreshed.

Returns:

a SQL expression, e.g. "NEXT_DAY(TRUNC(SYSDATE), 'MONDAY') + 15/24"

setInterval

public void setInterval(java.lang.String interval)

A datetime expression for calculating the interval between automatic refreshes. This property is ignored unless the refresh mode is set to REFRESH_MODE_SPECIFY. If the refresh mode is REFRESH_MODE_SPECIFY and the interval is set to null, then the materialized view refreshes only once (at the time specified in getStartWith()). If getStartWith also returns null then the view is never refreshed.

Parameters:

interval - a SQL expression, e.g. "NEXT_DAY(TRUNC(SYSDATE), 'MONDAY')"

setStaleness

public void setStaleness(MaterializedView.Staleness staleness)

Sets the relationship between the contents of the materialized view and the contents of the materialized view's masters

Parameters:

staleness - an int representing the staleness

getStaleness

public MaterializedView.Staleness getStaleness()

Gets the relationship between the contents of the materialized view and the contents of the materialized view's masters

setBuildType

public void setBuildType(MaterializedView.BuildType buildType)

Sets the type specified in the build clause

Parameters:

buildType - the build type

getBuildType

public MaterializedView.BuildType getBuildType()

Gets the type specified in the build clause

Returns:

the build type

setOnPrebuilt

public void setOnPrebuilt(MaterializedView.PrebuiltType onPrebuilt)

Sets whether this materialized view is prebuilt. This information is only used to create the materialized view and is ignored for updates of the view.

getOnPrebuilt

public MaterializedView.PrebuiltType getOnPrebuilt()

Gets whether this materialized view is prebuilt. This information is only used to create the materialized view and is ignored for updates of the view.

setUseNoIndex

public 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. The USING NO INDEX clause suppresses the creation of the default index.

isUseNoIndex

public 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. The USING NO INDEX clause suppresses the creation of the default index. This property is ignored by the database unless the query defining the materialized view is an aggregate query.

setIndexPercentFree

@Deprecated
public 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

The value of this property is ignored if you call updateObject on the MaterializedView because it is not supported in the ALTER MATERIALIZED VIEW statement. This property is ignored by the database unless the query defining the materialized view is an aggregate query.

Parameters:

indexPctFree -

getIndexPercentFree

@Deprecated
public 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

The value of this property is ignored if you call updateObject on the MaterializedView because it is not supported in the ALTER MATERIALIZED VIEW statement. This property is ignored by the database unless the query defining the materialized view is an aggregate query.

setIndexPercentUsed

@Deprecated
public 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

getIndexPercentUsed

@Deprecated
public int getIndexPercentUsed()

Deprecated. You cannot specify the Percent Used for an Index. This method has been deprecated

Returns:

null

setIndexInitTrans

@Deprecated
public 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

getIndexInitTrans

@Deprecated
public 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

setMaxTrans

@Deprecated
public 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

getMaxTrans

@Deprecated
public 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

setMinTrans

@Deprecated
public 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

getMinTrans

@Deprecated
public 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

setInitExtent

@Deprecated
public 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

getInitExtent

@Deprecated
public 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

setNextExtent

@Deprecated
public 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

getNextExtent

@Deprecated
public 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

setIndexMinExtent

@Deprecated
public 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

The value of this property is ignored if you call updateObject on the MaterializedView because it is not supported in the ALTER MATERIALIZED VIEW statement. This property is ignored by the database unless the query defining the materialized view is an aggregate query.

Parameters:

indexMinExtent -

getIndexMinExtent

@Deprecated
public 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

The value of this property is ignored if you call updateObject on the MaterializedView because it is not supported in the ALTER MATERIALIZED VIEW statement. This property is ignored by the database unless the query defining the materialized view is an aggregate query.

setIndexMaxExtent

@Deprecated
public 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

The value of this property is ignored if you call updateObject on the MaterializedView because it is not supported in the ALTER MATERIALIZED VIEW statement. This property is ignored by the database unless the query defining the materialized view is an aggregate query.

Parameters:

indexMaxExtent -

getIndexMaxExtent

@Deprecated
public 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

The value of this property is ignored if you call updateObject on the MaterializedView because it is not supported in the ALTER MATERIALIZED VIEW statement. This property is ignored by the database unless the query defining the materialized view is an aggregate query.

getTablespace

@Deprecated
public 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

The string of the name of the tablespace used by this materialized view. This property is relevant only if isUseNoIndex returns false This property is ignored by the database unless the query defining the materialized view is an aggregate query.

Returns:

the tablespace name or null

setTablespace

@Deprecated
public 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

Sets the string of the tablespace name. This property is ignored if isUseNoIndex() returns true. This property is ignored by the database unless the query defining the materialized view is an aggregate query.

Parameters:

tablespace - a string of the tablespace name

setCache

public void setCache(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.

isCache

public boolean isCache()

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.

setMasters

public void setMasters(java.lang.String[] masters)

getMasters

public java.lang.String[] getMasters()

getKeyType

public MaterializedView.RefreshWith getKeyType()

The key type. The property is only used in creating materialized views. It is ignored for updating materialized views.

setKeyType

public void setKeyType(MaterializedView.RefreshWith keyType)

The key type. The property is only used in creating materialized views. It is ignored for updating materialized views.

getUsingConstraints

public MaterializedView.UsingConstraints getUsingConstraints()

Returns whether or not the materialized view can used TRUSTED constraints as well as just ENFORCED constraints (the default). This lets Oracle Database use unenforced constraints, such as dimension relationships or constraints in the RELY state, rather than relying only on enforced constraints during the refresh operation. This property is relevant to Oracle 10g databases onwards. For other database types, this property should return null

setUsingConstraints

public void setUsingConstraints(MaterializedView.UsingConstraints usingConstraints)

Specifies whether or not the materialized view can use TRUSTED constraints as well as just ENFORCED constraints (the default). This lets Oracle Database use unenforced constraints, such as dimension relationships or constraints in the RELY state, rather than relying only on enforced constraints during the refresh operation. This property is relevant to Oracle 10g databases onwards. Do not set this property to anything other than null for other database types.

getRollbackSegmentType

public 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:

Returns:

the rollback type

See Also:

LOCAL is the default.

setRollbackSegmentType

public 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:

Parameters:

rollbackSegmentType - the rollback type

See Also:

LOCAL is the default.

getRollbackSegmentName

public java.lang.String getRollbackSegmentName()

The rollback segment name - ignored if the the rollback segment type is null or set to RS_NONE.

Returns:

the rollback segment name (or null for default)

setRollbackSegmentName

public 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.

Parameters:

rollbackSegmentName - the rollback segment name. Set to null or empty to use the default.

isDeclarative

public boolean isDeclarative()

Convinience method to check whether this mat view has a declarative query.

Specified by:

isDeclarative in interface SQLQueryOwner

setParallel

public void setParallel(int 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

getParallel

public int getParallel()

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

setCompression

public void setCompression(boolean compression)

Sets the compress property for the Table

Parameters:

compression -

isCompression

public boolean isCompression()

Gets the compress property for the Table