Database DataWarehousing (MOSC)

MOSC Banner

how to generate a materialised view in parallel by 2 users

edited May 1, 2014 12:00PM in Database DataWarehousing (MOSC) 4 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center