'Want to create a Materialized View on commit from a View which is in another Database using a Database Link
I am able to create a Materialized View(MV) on demand from another View which is in another database using database link. Now, the requirement is changed to show the commit changes immediately in the current view, so I want create a MV on commit, can I create a MV on commit using a view in another database with database link. If they is no way of creating it, then what aproach do I need to take for updating my MV on demand when the source view gets updated with new records.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|