Re: Mviews Refresh Timings

From: <>
Date: Mon, 9 Mar 2009 06:47:02 -0700 (PDT)
Message-ID: <>

Thanks David for suggestion,

What I am thinking to create one trigger on system level on "Truncate" specifically if segment is one of these
Mview. I can just create this trigger before starting this job.

As per my knowledge whenever we do complete refresh, Oracle first truncate the base mview and then will insert data into this.

So - trigger will help when truncate happened and later on I can track dba_mview,refresh_Time when it was completed.

Do you see this approach feasible/possible. ?

Regards, Received on Mon Mar 09 2009 - 08:47:02 CDT

Original text of this message