we have upgradaed the database from oracle 8i to oracle 10g. after this some store procedures failing(ora 1001, cluster invalid). I'm new to oracle and pro C. pls help me to odd out the cause.
The same thing was worked finely with the old database.
Currently we are checking the queries and procedures with evaluation version of oracle 10g.
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…