MATERIALIZED VIEW LOG - details about the sequence...
BazzaSep 10 2012 — edited Sep 10 2012Say you did:
CREATE MATERIALIZED VIEW LOG ON sales
WITH ROWID, SEQUENCE(amount_sold, time_id, prod_id)
INCLUDNG NEW VALUES;
Every row that goes into the snapshot log has a unique sequence id -
1) what sequence does it use?
I'm trying to work out what the max sequence id it would use before it started at the beginning again.