Making data available in a table all the time

Viewed 42

I'm currently using the below method to have data available in a table:

  1. A materialized view is fully refreshed (this process takes about 2 hours).
  2. The rows from the MV are inserted into my final table (FINAL_DATA).

This way, I am able to have data available in FINAL_DATA for the time that it takes for the MV to refresh. However, the data there is unavailable for the time between I delete all the rows and insert them again into FINAL_DATA. Ideally I would like data to be always available in FINAL_DATA. I have heard that there is a better way to achieve this using partitions. What that would be?

0 Answers
Related