Home IT-Blog Failsafe ORA-00942 "View or Table does not exist"
Failsafe ORA-00942 "View or Table does not exist" PDF Print
Tuesday, 08 August 2006 12:41

questionmark

 

There is something wrong..... I installed the new version of failsafe and could not add a Database, because of ORA-00942 "View or Table does not exist". So i checked by enabling the database trace (in the DBMS_MONITOR Package) and looking for the SQL-Statement in the dump-directory of the database.

Failsafe is looking for a table "v$controlfiO" in another installation for "v$controlfif", thought v$controlfile was meant and created a public synonym for it ("create synonym v$controlfiO for v$controlfile;") after this it worked. I will log a Service Request for this issue...

 

Add comment


Security code
Refresh