asked on

ORA-00600

Hi,
I' m using Oracle 11 G in windows 2008 r2 .
When I' m executing an SQL query I' m getting ORA-00600 error below ;
ORA-00600: internal error code, arguments: [130009], [5000], [1], [17],[1], [], [], []

The SQL is below,

select project_id, export_id, field_no, not_in_view, tab_no, filed,
fix_filed_name, agrigate_function, sort_by, force_value, rowid
from comm_present_fields where project_id = 3 and export_id = 6
and field_no <= 600 and not_in_view = 0 order by tab_no asc for update nowait
/

How can I prevent this error ?

Mark Geerlings

An ORA-00600 error is usually *NOT* caused by your code. These usually indicate a database problem of some kind. Oracle's web site has a page where you can look up what some (not all) ORA-00600 errors mean by providing the first argument or two that your ORA-00600 error returned.

You do have an account on "My Oracle Support" and a CSI# that you can use to open a Service Request with Oracle Support, if you need it, correct?

ASKER CERTIFIED SOLUTION

Akenathon

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

slightwv (䄆 Netminder)

I agree with the above posts about this being a pretty generic error and typically requires Support to help.

If you Google that error some of the results point to a corrupt index or chained rows on the table.

Might be worth a quick test to rebuild some indexes.

http://blog.nominet.org.uk/tech/2008/01/07/ora-00600-error-arguments-13009-5000-on-oracle-10202-database/

http://www.ssi-world.com/customerarea/ora00600.htm

orcun_turkec

ASKER

Thank you...