how to generate a materialised view in parallel by 2 users
We have the below issue:
We have a materialised view, this materialised view can be accessed by several users, running a report.
Note that each time we run the report this materialised view is destroyed\regenerated.
The first user generates the materialised view with the correct results but if at the same time a second user decides to run the report, then this user gets the below error msg:
ORA-00942 ‘The table or view does not exist’
Please advise if there is a workaround to avoid this problem.
DB Version: 11.2.0.4
Thanks in advance.