Printable View
Hello my client was attempting to drop an invalid procedure but when he did that as the owner of the procedure
he got this ORA-00600: internal error code, arguments: [4882], [104778064], [72136508], [104715400], [], [],
[], [].
some kind of dead lock. We attempted to drop the procedure using system and received same error. I feel that that procedure is somehow locked. I tried killing the session of that user but it didnt release the locks nor did it rollback anthing.
please help
thanks
Jigar
Check dba_ddl_locks to see if anybody else has that object locked. In general, ORA-600 messsages indicate a bug with oracle and should be reported to Oracle Support.
This is a 7.3.4 database. Please advice.
OK. Are you saying that there is no DBA_DDL_LOCKS or that you can't contact Oracle Support?
Yes dba_ddl_locks doesnt exists in 7.3.4
You've got a real problem. I'm not very fluent on 7.x, in 8.1.5 the view is created via catblock.sql.
Other than that, you could bounce the db and bring it up in restricted mode and drop it from there.