Home » SQL & PL/SQL » SQL & PL/SQL » ORA-0600 [17090]
ORA-0600 [17090] [message #19391] Thu, 14 March 2002 02:57 Go to next message
Hans Neckebroeck
Messages: 2
Registered: February 2002
Junior Member
Hello,

What causes the errror ORA-0600 [[17090]] and how can I fix this problem?

Regards,

Hans
Re: ORA-0600 [17090] [message #19392 is a reply to message #19391] Thu, 14 March 2002 03:50 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
can u explian how u got this error
Re: ORA-0600 [17090] [message #19395 is a reply to message #19391] Thu, 14 March 2002 05:01 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
what is your database version?

Check the alert log file located in the background_dump_dest directory
to find the real cause of the ORA-600 error.

This is typically caused by some space management error such as an ORA-1658 or ORA-1683. Resolve the space management issue and re-run the job.

ORA-1658 - "unable to create INITIAL extent for segment in tablespace %s"
ORA-1683 - "unable to extend index %s.%s partition %s by %s in tablespace %s"

If this is not the case, generate a trace file by setting the following
event in init.ora:

event = "600 trace name errorstack level 3"

Bounce the database and rerun the job.

If it errors out, it'll generate a trace file in udump directory.

if the problem still persist, then let me know,it most probably due to space management issue.

good luck!!!
Previous Topic: sequence
Next Topic: help! second half of procedure not executing
Goto Forum:
  


Current Time: Thu Apr 18 20:05:35 CDT 2024