This content has been marked as final. Show 2 replies
Have they ever refreshed successfully?
How are you logged on? The MV shows it is owned by user 'qqq'; are you connected as user 'qqq'?
Try using sql*plus, connecting as user 'qqq' and refreshing one of the MVs.
1) Try to Compile all the 3 M.view and Schedule it .
2) Once Job was successful, Check the M.view .
Note : Even if the M.v has compilation error , Schedule will refresh the M.view and You can able to see the transactions in the m.view