Re: oracle materialized view - refesh occuring but base tables not being deleted

From: Anurag Varma <avoracle_at_gmail.com>
Date: Fri, 15 Feb 2008 12:15:46 -0800 (PST)
Message-ID: <4b9bf7f1-f681-4ad6-8eb0-778e885fc209@s8g2000prg.googlegroups.com>


On Feb 15, 10:36 am, stre..._at_yahoo.co.uk wrote:
> hi,
>
> we have an application which uses materialized views. the refresh
> action (using fast refresh) executes without error but for some reason
> the base materialized views (<schema>.MLOG$_<table>) does not get
> deleted (we do a select count(1) from the base table). as i understand
> it the entries are supposed to be removed. a few additional peices of
> information:
> * the base tables are only used by one materialized view.
> * there have been problems with the refresh over the past few weeks
> failing until we increased the refesh interval (controlled by the
> application)
> * there are over 100,000,000 entries in the base table.
> i'm going to be investigating this in more detail myself over the next
> few days and will add anything i find.
> g

Look in dba_registered_snapshots to see if there are other registered entries for
the mview log. If there are additional entries, then you might want to manually
remove them using the unregister procedure.

Anurag Received on Fri Feb 15 2008 - 14:15:46 CST

Original text of this message