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 I selects the data from the Materializedview table, 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.