SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Log only specific column changes to the Materialized View Log

FormsSep 3 2015 — edited Sep 4 2015

Hi Gurus,

I have built a materialized view for Fast Refresh on a Base Table that has 10 columns.

Out of these 10 columns, the MV needs only 5 columns.

If there is any change to the Table on the other 5 columns which the MV is not using, I don't want the changes to be logged into the MV log.

This could save me considerable time on the Refresh operation.

Is there a way to achieve this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2015

Added on Sep 3 2015

4 comments

1,123 views