Materialized View Queries [Oracle]

Query	The Returned Rows Indicate	Resolution
MVIEWS-1	Materialized views which are defined in the Application Designer, but are not found in the database.	Use the Application Designer to build the materialized views.
MVIEWS-2	Materialized views which are defined in the database, but are not found in the Application Designer.	Drop the materialized view if it is not valid. Otherwise, define a new materialized view in the Application Designer.
MVIEWS-3	Materialized views which are missing a related language record.	Use the Application Designer to add a related language record for materialized views.

Query

The Returned Rows Indicate

Resolution

MVIEWS-1

Materialized views which are defined in the Application Designer, but are not found in the database.

Use the Application Designer to build the materialized views.

MVIEWS-2

Materialized views which are defined in the database, but are not found in the Application Designer.

Drop the materialized view if it is not valid.

Otherwise, define a new materialized view in the Application Designer.

MVIEWS-3

Materialized views which are missing a related language record.

Use the Application Designer to add a related language record for materialized views.