| 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 This property represents the local rollback segment used by the Oracle Materialized View. DATATYPE: String. |
| LogUpdates | This property represents Determines whether or not the Oracle Materialized View logs updates. DATATYPE: Boolean. |
| MasterRollbackSegment | Master This property represents the master rollback segment used by the Oracle Materialized View. DATATYPE: String. |
| MaxExtents | Maximum This property represents the maximum extents of the Oracle Materialized View. DATATYPE: Integer.This property represents the maximum |
| MaxTransactions | Maximum transactions of the Oracle Materialized View. DATATYPE: Integer. |
| MinExtents | Minimum This property represents the minimum extents of the Oracle Materialized View. DATATYPE: Integer.This property |
| Name | Name represents the name of the Oracle Materialized View. DATATYPE: String. |
| NextExtent | Next This property represents the next extent of the Oracle Materialized View. DATATYPE: Integer. |
| OnPrebuiltTable | Determines whether This property represents whether or not the Oracle Materialized View is built on an existing table. DATATYPE: Boolean. |
| Owner | Owner This property represents the owner of the Oracle Materialized View. DATATYPE: String.This |
| ParallelDegree | Parallel property represents the parallel degree of the Oracle Materialized View. DATATYPE: Integer.This |
| PercentFree | Percent property represents the percent free of the Oracle Materialized View. DATATYPE: Integer.This property represents the |
| PercentIncrease | Percent percent increase of the Oracle Materialized View. DATATYPE: Integer. |
| PercentUsed | Percent This property represents the percent used of the Oracle Materialized View. DATATYPE: Integer. |
| PostSQL | This is the PostSQL of the Oracle Materialized View. DATATYPE: String.This is |
| PreSQL | the PreSQL of the Oracle Materialized View. DATATYPE: String. |
| Query | This property represents the SQL query used to generate the data in the Oracle Materialized View. DATATYPE: String. |
| QueryRewrite | This property represents Determines whether or not the Oracle Materialized View uses query rewrite. DATATYPE: Boolean. |
| RefreshInterval | Refresh This property represents the refresh interval used by the Oracle Materialized View. DATATYPE: Integer.This property represents the |
| RefreshIntervalUnit | Unit unit of the refresh interval used by the Oracle Materialized View. DATATYPE: String. Can be "DAYS", "HOURS", "MINUTES" or "SECONDS".This property represents the refresh Valid values are: DAYS, HOURS, MINUTES, and SECONDS. DATATYPE: String. |
| RefreshMechanism | Refresh mechanism used by the Oracle Materialized View. DATATYPE: String. Can be "Valid values are: ON COMMIT", " ON DEMAND" or "AUTOMATICALLY".This property represents the refresh , and AUTOMATICALLY. DATATYPE: String. |
| RefreshMethod | Refresh method used by the Oracle Materialized View. Valid values are: ROWID and PK. DATATYPE: String. Can be "ROWID" or "PK". |
| RefreshType | Type This property represents the type of refresh done by the Oracle Materialized View. DATATYPE: String. Can be "FAST", "COMPLETE", "FORCE" or "NEVER".Valid values are: FAST, COMPLETE, FORCE, and NEVER. DATATYPE: String. |
| Tablespace | Tablespace This property represents the tablespace where the Oracle Materialized View is located. DATATYPE: String. |
| Updatable | Determines whether This property represents whether or not the Oracle Materialized View is updatable. DATATYPE: Boolean. |