Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference
11g Release 1 (11.1.1.4.0)

E13403-05

oracle.javatools.db.ora
Class MaterializedView

java.lang.Object
  extended by oracle.javatools.db.AbstractDBObject
      extended by oracle.javatools.db.AbstractBuildableObject
          extended by oracle.javatools.db.AbstractSystemObject
              extended by oracle.javatools.db.AbstractSchemaObject
                  extended by oracle.javatools.db.Relation
                      extended by oracle.javatools.db.Table
                          extended by 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 :


getParallel

public int getParallel()
Set the degree of parallelism (the number of parallel threads used in the parallel operation) where :


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


Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference
11g Release 1 (11.1.1.4.0)

E13403-05

Copyright © 1997, 2011, Oracle. All rights reserved.