-
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.
Jeff Hunter
-
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?
Jeff Hunter
-
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.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|