Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Materialized view log - order of changes
Hi all,
i am working with Oracle 8.1.7.0.0 and need to keep updated one table
with the changes from another table. The idea i am following is through
materialized view log that tracks all the changes made to the master
table.
Now, if there is more than one change on the same row in the master table i get, in mlog$_table, couples of rows with old and new values (OLD_NEW$$ fields); my problem is how to know the order the changes were made: SNAPTIME$$ and CHANGE_VECTOR$$ columns don't help. If i add a date field to the log table with sysdate as default value it is not enough (2 subsequent updates have same date). I would like to use SEQUENCE option in the declaration of the MV log but it is not available in Oracle 8.
Any idea or, suggestion would be appreciated.
Thanks in advance,
-- FabioReceived on Fri Feb 10 2006 - 04:43:57 CST