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!

Oracle Materialized View - Source table locking

user13696785Oct 14 2015 — edited Oct 15 2015

Dear Experts,

Please help me as we are going to create MV for our production critical table having 1279688 records.

When creating/refreshing a Materialized view, will oracle lock the source table(s) and how much time it will take for creation.

Thanks..

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2015

Added on Oct 14 2015

#general-database-discussions

3 comments

1,104 views