Monday, August 12, 2013

Database -- ORA-700 Soft Internal Error

I wrote this post because the error number 700 attracted my attention..
ORA-700 errors are introduced in Oracle 11G.
These are referred as internal errors like ORA-00600, but ORA-00700 errors are named as Soft Internal Errors, and do not cause anything fatal to occur in the process.

Some(less harmful) ORA-00600 errors,which are in Oracle 10G, are similar to ORA-00700 errors in Oracle 11G.
For example, if the code finds that a hint in a query is corrupt, it can just raise a soft-assert since the query can be run without the hint being used, and so doesn't need to crash the process. So in 11g, for such a condition an ORA-700 error would be raised.

Note that ; these errors take place in the error lookup tool, which is named as ORA-600/ORA-7445/ORA-700 Error Look-up Tool

No comments :

Post a Comment