Materialized View Log
Posted on 2004-04-15
I have created a materialized log for a table.
T_enterprise_track_id, service_id, track_no, status_id, last_accessed_time, activity_id
The column last_accessed_time is updated 30 times a sec. for the new inserted record.
My materialized view contains one column from that table (status_id), which has less updates.
My Materialized view log size will become huge. Since it log unwanted changes
Is there a way to log the fields which selected in the materialized view only not all columns.