HAi,
i have created a materialized view and scheduled it it run every one hour .
Refresh option is force.
At the time of materialized view refresh, if some report queries that MAterializedview table for data, the query fails.
The query fails and reports error "invalid rowid"
and sometimes no rows are returned.
Is it possible for that query to wait in a queue till the end of refresh time.
how to solve this.
Reply With Quote