| Property | Description |
|---|
| Determines whether the Oracle Materialized View uses cached data. DATATYPE: Boolean. |
| Compress property of the Oracle Materialized View. DATATYPE: Boolean. |
| Description of the Oracle Materialized View. DATATYPE: String. |
| Determines whether the Oracle Materialized View is filled immediately. DATATYPE: Boolean. |
| 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. |
| Generate PostSQL of the Oracle Materialized View. DATATYPE: Boolean. |
| Generate PretSQL of the Oracle Materialized View. DATATYPE: Boolean. |
| GUID of the Oracle Materialized Query. DATATYPE: String. |
| Returns the Oracle Materialized View ID. DATATYPE: Integer. |
| Initial extent of the Oracle Materialized View. DATATYPE: Integer. |
| Initial transactions of the Oracle Materialized View. DATATYPE: Integer. |
| Local rollback segment used by the Oracle Materialized View. DATATYPE: String. |
| Determines whether the Oracle Materialized View logs updates. DATATYPE: Boolean. |
| Master rollback segment used by the Oracle Materialized View. DATATYPE: String. |
| Maximum extents of the Oracle Materialized View. DATATYPE: Integer. |
| Maximum transactions of the Oracle Materialized View. DATATYPE: Integer. |
| Minimum extents of the Oracle Materialized View. DATATYPE: Integer. |
| Name of the Oracle Materialized View. DATATYPE: String. |
| Next extent of the Oracle Materialized View. DATATYPE: Integer. |
| Determines whether the Oracle Materialized View is built on an existing table. DATATYPE: Boolean. |
| Owner of the Oracle Materialized View. DATATYPE: String. |
| Parallel degree of the Oracle Materialized View. DATATYPE: Integer. |
| Percent free of the Oracle Materialized View. DATATYPE: Integer. |
| Percent increase of the Oracle Materialized View. DATATYPE: Integer. |
| Percent used of the Oracle Materialized View. DATATYPE: Integer. |
| PostSQL of the Oracle Materialized View. DATATYPE: String. |
| PreSQL of the Oracle Materialized View. DATATYPE: String. |
| SQL query used to generate the data in the Oracle Materialized View. DATATYPE: String. |
| Determines whether the Oracle Materialized View uses query rewrite. DATATYPE: Boolean. |
| Refresh interval used by the Oracle Materialized View. DATATYPE: Integer. |
| Unit of the refresh interval used by the Oracle Materialized View. Valid values are: DAYS, HOURS, MINUTES, and SECONDS. DATATYPE: String. |
| Refresh mechanism used by the Oracle Materialized View. Valid values are: ON COMMIT, ON DEMAND, and AUTOMATICALLY. DATATYPE: String. |
| Refresh method used by the Oracle Materialized View. Valid values are: ROWID and PK. DATATYPE: String. |
| Type of refresh done by the Oracle Materialized View. Valid values are: FAST, COMPLETE, FORCE, and NEVER. DATATYPE: String. |
| Tablespace where the Oracle Materialized View is located. DATATYPE: String. |
| Determines whether the Oracle Materialized View is updatable. DATATYPE: Boolean. |