ORA-00604 error occurred at recursive SQL level 1
Hi,
Recently, I have been given a database to fine tune. I started off with identifying the users which are no longer used. So went on to drop them. But with trying to drop any user, i get the error
ORA-00604 error occurred at recursive SQL level 1
followed by ORA-00600 and ORA-00607 error codes.
I tried executing catalog.sql as sys user.. but i got the same error many times in the script.
After executing the script I again tried dropping a table in one of the schemas but it did not work. The application hangs.
Can anyone suggest a solution to this ?
I am not sure how and when this problem must have first arisen. All I have to do is solve this issue out.
Thanx in advance.
Trupti