Home » SQL & PL/SQL » SQL & PL/SQL » Fast refresh won't empty the mlog table. (10.2.0.1.0)
Fast refresh won't empty the mlog table. [message #327222] Sun, 15 June 2008 07:21 Go to next message
walter01
Messages: 28
Registered: April 2008
Junior Member
Hi,

I have an mview that's periodically being fast refreshed by means of a job. The problem I have is that the mview is being refreshed but the update records aren't removed from the mlog table. The base table of the mview is on a remote database where also the mlogs are kept.
Any ideas on what I could be doing wrong ?
I don't have this problem with some of my other fast refreshed mviews that are based on remote database tables.

thanks,

Walter
Re: Fast refresh won't empty the mlog table. [message #327228 is a reply to message #327222] Sun, 15 June 2008 08:08 Go to previous message
walter01
Messages: 28
Registered: April 2008
Junior Member
Solved.

I think something went wrong while setting everything (tables/mlog/mviews) up the first time. I dropped and created everything again and now it works as it should.

Walter
Previous Topic: Catch new update , new insert into a table and write to a file!
Next Topic: Trigger Problem
Goto Forum:
  


Current Time: Wed Dec 07 14:58:23 CST 2016

Total time taken to generate the page: 0.09174 seconds