Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
When running a DROP MATERIALIZED VIEW the session hangs Due to the JI contention.
2. Take the refresh job offline and removed the job.
3. Finally dropped the MView BR_SEED.ZIP_US which worked , we do not see the job or the Mview any more.
Solution
1. Killed the running job. Check DBMS_JOBS_RUNNING view here.2. Take the refresh job offline and removed the job.
3. Finally dropped the MView BR_SEED.ZIP_US which worked , we do not see the job or the Mview any more.