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.