Re: Materialized View Question

A MV uses an internal table MLOG_$<source_table_name> to log changes.

This table is populated by an internal trigger when changes are made
to the source table.

This table is in turn used to populate the target table. That is done
when a dbms_mview.refresh is requested, either manually or via
dbms_job.

When applying archive logs in a database recovery, the database is not
open.

The source table will change, but I do not believe the MLOG_$ table
will be updated (database is not open). The changes will not then
propogate to the target table when a refresh is requested.

I would think that a complete refresh would be required in this case.

The caveat is that I have never tried this particular scenario.

Perhaps you should set up a test to see exactly what happens.

HTH

Jared

.

Relevant Pages

  • RE: password fields
    ... I can buy the "refresh" reason but what about setting to a value via a database call: ... they won't populate, why? ... "John Sivilla" wrote: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Tables and inserting rows
    ... endorsements would populate for that 1 vehicle. ... Is it possible to rename the bookmark or do I have to use the other option ... Dim myDataBase As Database ... Dim myActiveRecord As Recordset ...
    (microsoft.public.word.vba.general)
  • Re: Tables and inserting rows
    ... I have the main template and then am inserting a document which has all the ... Dim myDataBase As Database ... Dim myActiveRecord As Recordset ... 'Add a row to the table and populate the cells in that row with the ...
    (microsoft.public.word.vba.general)
  • Re: Tables and inserting rows
    ... bookmark (rather than try and do something with autotext). ... Dim myDataBase As Database ... Dim myActiveRecord As Recordset ... 'Add a row to the table and populate the cells in that row with the ...
    (microsoft.public.word.vba.general)
  • Re: Tables and inserting rows
    ... Dim myDataBase As Database ... Dim myActiveRecord As Recordset ... 'Add a row to the table and populate the cells in that row with the data ... Set drow = dtable.Rows.Add ...
    (microsoft.public.word.vba.general)