Does Oracle Provide Any Package To Deal With Materialized Views?

1.	Does Oracle Provide Any Package To Deal With Materialized Views?
Answer» You can use the dbms_mview PACKAGE to deal with materialized views. It is ALSO called dbms_snapshot. Some of the procedures provided by the dbms_mview packages are as given follows: BEGIN_TABLE_REORGANIZATION – Performs a process to preserve materialized view data NEEDED for refresh. END_TABLE_REORGANIZATION – Ensures that the materialized view data for the MASTER table is valid and that the master view or potential materialized view. EXPLAIN_MVIEW – Explains what is possible with a materialized view or potential materialized views. EXPLAIN_REWRITE – Explains why a QUERY failed to rewrite. You can use the dbms_mview package to deal with materialized views. It is also called dbms_snapshot. Some of the procedures provided by the dbms_mview packages are as given follows:

Answer»

You can use the dbms_mview PACKAGE to deal with materialized views. It is ALSO called dbms_snapshot.

Some of the procedures provided by the dbms_mview packages are as given follows:

BEGIN_TABLE_REORGANIZATION – Performs a process to preserve materialized view data NEEDED for refresh.
END_TABLE_REORGANIZATION – Ensures that the materialized view data for the MASTER table is valid and that the master view or potential materialized view.
EXPLAIN_MVIEW – Explains what is possible with a materialized view or potential materialized views.
EXPLAIN_REWRITE – Explains why a QUERY failed to rewrite.

You can use the dbms_mview package to deal with materialized views. It is also called dbms_snapshot.

Some of the procedures provided by the dbms_mview packages are as given follows:

Discussion