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!

Alternative to COMPLETE refresh Materialized View

455440Jan 7 2008 — edited Jan 8 2008

Hi All,

We have a COMPLETE refresh materialized view which takes more than 2 hours to get refreshed. It cannot be FAST refreshed due to limitations with FAST refresh options.
Also, the base query of the materialized view cannot be broken in to small queries to be able to use child and Master materialized views.

What could be the alternatives to materialized views?

Thanks,
Kishore

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 5 2008

Added on Jan 7 2008

#general-database-discussions

4 comments

503 views