Amaterialized view refresh job was broken (failures = 16). I tried to manually run the job (exec dbms_job.run(70)) and it failed. Here is the error in thealert log:
Errors in file C:\OraDBA\eweb\udump\ORA00314.TRC:
ORA-12012: error onauto execute of job 70
ORA-12008: error in snapshot refresh path
ORA-01752:cannot delete from view without exactly one key-preserved table
ORA-06512: at"SYS.DBMS_SNAPSHOT", line 587
ORA-06512: at "SYS.DBMS_SNAPSHOT", line644
ORA-06512: at "SYS.DBMS_IREFRESH", line 561
ORA-06512: at"SYS.DBMS_REFRESH", line 207
ORA-06512: at line 1
Next, I trieddbms_snapshot.refresh('cap_company','c') and got the ORA-1772, etc. errors.
Ithen tried to drop the materialized view and got this error:
ORA-00600: internalerror code, arguments: [17009], [3], [71226860], [76255984], [66067904], [],[], []
The master table is on an 8.1.5 database running on Sun Solaris for Intel5.7.
A materialized view log exists.