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:



Discussion

No Comment Found