I'm currently using the below method to have data available in a table:
- A materialized view is fully refreshed (this process takes about 2 hours).
- 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?