Page History
Public Methods
| Method | Description |
|---|---|
| BoundAttachments | Returns the BoundAttachments collection of this Object. |
| ObjectPermissions | Returns the collection of Object Permissions for this object. |
| UserComments | Returns a collection of user comments associated with this Object. |
Public Properties
| Property | Description |
|---|---|
| CachedData |
| Determines whether |
| the Oracle Materialized View uses cached data. DATATYPE: Boolean. |
| Compress |
| Compress property of the Oracle Materialized View. DATATYPE: Boolean. |
| Description | Description of the Oracle Materialized View. DATATYPE: String. |
| FillImmediate |
| Determines whether |
| the Oracle Materialized View is |
| filled immediately. DATATYPE: Boolean. |
| FirstRefresh | Time of the first refresh of the Oracle Materialized View. |
| Must be in the |
| following format: dd-Mon-YYYY HH:MM PP |
| where the time is in 12-hour format and P is either AM or PM. DATATYPE: String. |
| GenPostSQL | Generate PostSQL of the Oracle Materialized View. DATATYPE: Boolean. |
| GenPretSQL |
| Generate PretSQL of the Oracle Materialized View. DATATYPE: Boolean. |
| GUID | GUID of the Oracle Materialized Query. DATATYPE: String. |
| ID | Returns the Oracle Materialized View ID. DATATYPE: Integer. |
| InitialExtent | Initial extent of the Oracle Materialized View. DATATYPE: Integer. |
| InitialTransactions | Initial transactions of the Oracle Materialized View. DATATYPE: Integer. |
| LocalRollbackSegment | Local rollback segment used by the Oracle Materialized View. DATATYPE: String. |
| LogUpdates |
| Determines whether |
| the Oracle Materialized View logs updates. DATATYPE: Boolean. |
| MasterRollbackSegment | Master rollback segment used by the Oracle Materialized View. DATATYPE: String. |
| MaxExtents | Maximum extents of the Oracle Materialized View. DATATYPE: Integer. |
| MaxTransactions | Maximum |
| transactions of the Oracle Materialized View. DATATYPE: Integer. |
| MinExtents | Minimum extents of the Oracle Materialized View. DATATYPE: Integer. |
| Name | Name of the Oracle Materialized View. DATATYPE: String. |
| NextExtent | Next extent of the Oracle Materialized View. DATATYPE: Integer. |
| OnPrebuiltTable |
| Determines whether |
| the Oracle Materialized View is built on an existing table. DATATYPE: Boolean. |
| Owner | Owner of the Oracle Materialized View. DATATYPE: String. |
| ParallelDegree | Parallel degree of the Oracle Materialized View. DATATYPE: Integer. |
| PercentFree | Percent free of the Oracle Materialized View. DATATYPE: Integer. |
| PercentIncrease | Percent |
| increase of the Oracle Materialized View. DATATYPE: Integer. |
| PercentUsed | Percent |
| used of the Oracle Materialized View. DATATYPE: Integer. |
| PostSQL | PostSQL of the Oracle Materialized View. DATATYPE: String. |
| PreSQL |
| PreSQL of the Oracle Materialized View. DATATYPE: String. |
| Query |
| SQL query used to generate the data in the Oracle Materialized View. DATATYPE: String. |
| QueryRewrite | Determines whether the Oracle Materialized View uses query rewrite. DATATYPE: Boolean. |
| RefreshInterval | Refresh interval used by the Oracle Materialized View. DATATYPE: Integer. |
| RefreshIntervalUnit | Unit of the refresh interval used by the Oracle Materialized View. |
| Valid values are: DAYS, HOURS, MINUTES, and SECONDS. DATATYPE: String. | |
| RefreshMechanism | Refresh |
| mechanism used by the Oracle Materialized View. |
| Valid values are: ON COMMIT |
| , |
| ON DEMAND |
| , and AUTOMATICALLY. DATATYPE: String. | |
| RefreshMethod | Refresh |
| method used by the Oracle Materialized View. Valid values are: ROWID and PK. DATATYPE: String. |
| RefreshType | Type of refresh done by the Oracle Materialized View. |
| Valid values are: FAST, COMPLETE, FORCE, and NEVER. DATATYPE: String. | |
| Tablespace | Tablespace |
| where the Oracle Materialized View is located. DATATYPE: String. |
| Updatable |
| Determines whether |
| the Oracle Materialized View is updatable. DATATYPE: Boolean. |
| Info | ||
|---|---|---|
| ||