lundi 29 décembre 2014

ORA-08102 while creating a view


I am learning PL/SQL programming. I'm trying to create a view with the following statement:



create or replace view viewName as select ID from employees;


The view creation throws the following error:



ORA-00604 error occurred at recursive level 1
ORA-08102 Index not found, obj #39 , file 1 block 61248


How can I fix it?


The problem is with all objects, procedures,functions,views and i am using the HR Database of Oracle 11G for learning purposes.





Aucun commentaire:

Enregistrer un commentaire