Hello, there is a need to use a mat view to collect data from a table in another database. It was decided to use the FAST method as it does not update the table completely, but only the changes. But since the historical data and generally entered previously can be changed, there was a doubt. Does the mat update the old data with the FAST update method, or does it only add new data?
1 answer
Oracle rolls incremental changes to MV ( Materialized View ) from MV Log. Accordingly, all the change vectors of the base tables (found in MV Log) will be applied to the corresponding MVs.
MaxU MaxU
52.2k 6 18 51
- MaxU as far as I understand, you need to create mv log, but how and by what rules is it created? After all, I have to create it myself before creating a presentation mat. - Andrey
- @ Andrei, here is an example - MaxU
- MaxU, thank you, if something is not clear then I will speak in this thread. - Andrei
- MaxU, but please tell me, if my query goes to a table that is in a different database, but also oro-table, that is, through dibilink, and I do a view mat for this query, will it be updated using the FAST method? Or, through dibilink, this method does not work and it will be updated with a compile no matter what I put on it? Or is it just in case dibilink to another base is not Oracle? - Andrei
- @ Andrei, I don’t know - I have to try - MaxU February
|