Home » RDBMS Server » Server Administration » invalid objects compilation error
invalid objects compilation error [message #51031] Mon, 22 April 2002 05:54 Go to next message
Seldon1985
Messages: 1
Registered: April 2002
Junior Member
Does any one has any idea how to take care of this error messages?

SQL> alter VIEW CORRANA1.CAP04 compile;
alter VIEW CORRANA1.CAP04 compile
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded

I have more than 400 INVALID objects in the database. When I try to compile these objects I get error after couple of them compiled. Why? Does dompilation on INVALID objects such as view create problems?

Please need help badly!!!!!

Thanks!!!!!
Re: invalid objects compilation error [message #51032 is a reply to message #51031] Mon, 22 April 2002 06:05 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
You need to increase the open_cursors parameter in your initSID.ora file and restart your database.
Previous Topic: urgent - accessing oracle7 from oracle8i or vice versa within the same server
Next Topic: Temporary Data Files
Goto Forum:
  


Current Time: Wed Dec 25 09:19:08 CST 2024