Versions Compared

Old Version 2

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 3

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Public Methods

MethodDescription

Returns the BoundAttachments collection of this Object.

Returns the collection of Object Permissions for this object.

Returns a collection of user comments associated with this Object.

Public Properties

PropertyDescription
This property represents

Determines whether
or not
the Oracle Materialized View uses cached data. DATATYPE: Boolean.
This is the

Compress property of the Oracle Materialized View. DATATYPE: Boolean.
This is the

Description of the Oracle Materialized View. DATATYPE: String.
This property represents

Determines whether
or not
the Oracle Materialized View is
be
filled immediately. DATATYPE: Boolean.
This property represents the time

Time of the first refresh of the Oracle Materialized View.
DATATYPE: String.
Must be in the
form "
following format: dd-Mon-YYYY HH:MM PP
" This is the
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.
This is the

Generate PretSQL of the Oracle Materialized View. DATATYPE: Boolean.
This is the

GUID of the Oracle Materialized Query. DATATYPE: String.

Returns the Oracle Materialized View ID. DATATYPE: Integer.
This property represents the initial

Initial extent of the Oracle Materialized View. DATATYPE: Integer.
This property represents the initial

Initial transactions of the Oracle Materialized View. DATATYPE: Integer.

This property represents the local rollback segment used by the Oracle Materialized View. DATATYPE: String.

This property represents whether or not the Oracle Materialized View logs updates. DATATYPE: Boolean.

This property represents the master rollback segment used by the Oracle Materialized View. DATATYPE: String.

This property represents the maximum extents of the Oracle Materialized View. DATATYPE: Integer.

This property represents the maximum transactions of the Oracle Materialized View. DATATYPE: Integer.

This property represents the minimum extents of the Oracle Materialized View. DATATYPE: Integer.

This property represents the name of the Oracle Materialized View. DATATYPE: String.

This property represents the next extent of the Oracle Materialized View. DATATYPE: Integer.

This property represents whether or not the Oracle Materialized View is built on an existing table. DATATYPE: Boolean.

This property represents the owner of the Oracle Materialized View. DATATYPE: String.

This property represents the parallel degree of the Oracle Materialized View. DATATYPE: Integer.

This property represents the percent free of the Oracle Materialized View. DATATYPE: Integer.

This property represents the percent increase of the Oracle Materialized View. DATATYPE: Integer.

This property represents the percent used of the Oracle Materialized View. DATATYPE: Integer.

This is the PostSQL of the Oracle Materialized View. DATATYPE: String.

This is the PreSQL of the Oracle Materialized View. DATATYPE: String.

This property represents the SQL query used to generate the data in the Oracle Materialized View. DATATYPE: String.

This property represents whether or not the Oracle Materialized View uses query rewrite. DATATYPE: Boolean.

This property represents the refresh interval used by the Oracle Materialized View. DATATYPE: Integer.

This property represents the 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 mechanism used by the Oracle Materialized View. DATATYPE: String. Can be "ON COMMIT", "ON DEMAND" or "AUTOMATICALLY".

This property represents the refresh method used by the Oracle Materialized View. DATATYPE: String. Can be "ROWID" or "PK".

This property represents the type of refresh done by the Oracle Materialized View. DATATYPE: String. Can be "FAST", "COMPLETE", "FORCE" or "NEVER".

This property represents the tablespace where the Oracle Materialized View is located. DATATYPE: String.

This property represents whether or not the Oracle Materialized View is updatable. DATATYPE: Boolean.
Info
titleSee Also