Oracle Database Discussions

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!

Disabling Materialized View Logs for a session

813236Nov 11 2010 — edited Nov 12 2010

Hi all.

I was wondering if it is possible to disable the fast refresh log for materialized views for just a given session. So for all other sessions except this one the log would be added to. I'm using 11g.

In Oracle Database 11g, The Complete Reference on page 447 it states:
"As of Oracle 11g, the capture of changes in materialized view logs can be disabled for an individual session while logging continues for changes made by other sessions". But no instructions are given

Does anyone know how to do this? I have not been able to find the answer by looking around.

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 10 2010

Added on Nov 11 2010

#general-database-discussions

2 comments

400 views