How to use Oracle created snapshot refresh log manually.
Posted on 2001-07-26
Is it possbile to manually read Oracle's snapshot (materiallized view) refresh log? I would like to allow Oracle to automatically capture changes to a master table in its snapshot log file, then, use that log to manually update another series of tables based on what changed in the first master table. In particular, the deletes done in the master I may need to remove from secondary tables.