Answered Questions

  • What is Materialised View?

    Star Read Best Answer

    Editorial / Best Answer

    Answered by: Renu

    • Jan 26th, 2007


    Materialized View stores both - definition of the view and rows resulted from execution of the viewMain disadvantage of materialized view is that, its contents get outdated when underlying base table is modified .U can refresh Materialized View using DBMS_MVIEW.REFRESH

    thiru

    • Jun 26th, 2014

    Its a one of the oracle object,its physical storage on the disk then (dbms_refresh)

    shanitha

    • Sep 11th, 2012

    Materialized view is a database object that contains the results of a query..