MV Refresh to a specific SCN/PIT or consistently
From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Thu, 4 Jul 2013 16:12:05 -0300
Message-ID: <CAJ2dSGQnjmhu_mS9OZC4gngq=ZAP5M6V_Qo1Du33T3t2wJAZ1g_at_mail.gmail.com>
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).
Date: Thu, 4 Jul 2013 16:12:05 -0300
Message-ID: <CAJ2dSGQnjmhu_mS9OZC4gngq=ZAP5M6V_Qo1Du33T3t2wJAZ1g_at_mail.gmail.com>
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.-
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 04 2013 - 21:12:05 CEST