Re: MV Refresh to a specific SCN/PIT or consistently
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- Date: Thu, 4 Jul 2013 17:10:43 -0300
Hi,
Thanks, I started looking at refresh groups and they are definitely what
we need. I actually went back to the design document, and the refresh
groups are there... they are just not created in the database, which is
strange because the architecture document and the initial deploy were done
by the same architect.
I knew there had to be an easy way to do this. :-)
cheers
Alan.-
On Thu, Jul 4, 2013 at 4:44 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>wrote:
> Couldn't you just write a shell script to generate the necessary commands,
> then kick them all off at once as detached shell scripts? Or even use DBMS
> scheduler jobs to do it?
>
> Sent from my iPad
>
> On Jul 4, 2013, at 2:12 PM, Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
> wrote:
>
> > Hi,
> > We have a set of (near 700) tables (about 300G) that we need to
> replicate
> > every night and keep static. The idea is that we have an environment
> frozen
> > to the day before where we can run certain reports and stuff like that.
> The
> > architect decided to implement materialized views to solve this problem.
> > However, we are now facing the problem that since the MV refresh doesn't
> > happen at the same time for all the tables (some take up to an hour) we
> end
> > up with inconsistent data (child records with no parent).
> >
> > We are looking for a way to keep the data consistent. We thought of
> using
> > the SCN, but that would require manually issuing the refresh statement
> > which won't happen since it's a daily task.
> >
> > Does anyone have any idea, insight, notion or experience about something
> > like this?
> >
> > This is on 11.2.0.3 on exadata
> >
> > Thanks
> > Alan.-
> >
> >
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
