ORA-12012 ORA-12008 ORA-942 Materialized view Job Fails
Refreshing a Materialized View via the Oracle job scheduler reports the following errors, however manual refresh succeeds. Troubleshooting steps: Object Privileges – If the owner has not granted explicit rights to these objects the scheduled job will fail. To implement the solution, please execute the following steps: Example: If the mview is REFRESH FAST type, … Read more