-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|