Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Materialized view log - order of changes

Materialized view log - order of changes

From: Fabio <fab.valeri_at_gmail.com>
Date: 10 Feb 2006 02:43:57 -0800
Message-ID: <1139568237.365072.289750@g44g2000cwa.googlegroups.com>


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,

--
Fabio
Received on Fri Feb 10 2006 - 04:43:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US