ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string] Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include:timeouts file corruption failed data checks in memory hardware, memory, or I/O errors incorrectly restored files The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle. Action: Report this error to Oracle Support Services after gathering the following information:events that led up to the error the operations that were attempted that led to the error the conditions of the operating system and databases at the time of the error any unusual circumstances that occurred before receiving the ORA-00600 message contents of any trace files generated by the error the relevant portions of the Alter files Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.
ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include:timeouts file corruption failed data checks in memory hardware, memory, or I/O errors incorrectly restored files The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle.Action: Report this error to Oracle Support Services after gathering the following information:events that led up to the error the operations that were attempted that led to the error the conditions of the operating system and databases at the time of the error any unusual circumstances that occurred before receiving the ORA-00600 message contents of any trace files generated by the error the relevant portions of the Alter files Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.
Personal Oracle8i Release 8.1.7.0.0
执行一下这两条语句,看看结果:select obj#,owner#,type# from sys.obj$ where name = '你的package名'; select * from procedure$ where obj# in (上面查出来的obj#);
select obj#,owner#,type# from sys.obj$ where name = '你的package名'; 68571 46 9(46为我的用户,所以只是选了46) select * from procedure$ where obj# in (上面查出来的obj#); 无记录?????
你的数据库做过升级吗?奇怪。手工修补一下试试看吧:insert into procedure$ values (68571,'--------------------------------',null,2); 然后再试试DROP
Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include:timeouts file corruption failed data checks in memory hardware, memory, or I/O errors incorrectly restored files The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle. Action: Report this error to Oracle Support Services after gathering the following information:events that led up to the error the operations that were attempted that led to the error the conditions of the operating system and databases at the time of the error any unusual circumstances that occurred before receiving the ORA-00600 message contents of any trace files generated by the error the relevant portions of the Alter files Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.
:(
file corruption
failed data checks in memory
hardware, memory, or I/O errors
incorrectly restored files
The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle.Action: Report this error to Oracle Support Services after gathering the following information:events that led up to the error
the operations that were attempted that led to the error
the conditions of the operating system and databases at the time of the error
any unusual circumstances that occurred before receiving the ORA-00600 message
contents of any trace files generated by the error
the relevant portions of the Alter files
Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.
select * from procedure$ where obj# in (上面查出来的obj#); 无记录?????
然后再试试DROP
如方便的话能简单说一下原理吗