Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00600: internal error code
ORA-00600: internal error code [message #154170] Fri, 06 January 2006 01:47 Go to next message
war123
Messages: 8
Registered: November 2005
Junior Member
Hi

I have a code
CREATE TABLE AT
{
ID NUMBER(10);
}
PARTITION BY RANGE (ID)
(
PARTITION AR VALUES LESS THAN (MAXVALUE)
);

CREATE OR REPLACE VIEW A
AS
SELECT * FROM AT;

CREATE OR REPLACE TRIGGER ATr
INSTEAD OF INSERT ON AT
REFERENCING NEW AS NEW OLD AS OLD
BEGIN
SplitPartitionAR(); --Split partition AR into 2 partion
INSERT INTO AT(ID) VALUES (:New.ID);
END ATr;


CREATE OR REPLACE PROCEDURE Remove AS
BEGIN
Remove some partitions();
END;


So, I uses stress application to insert into View A, it split my partition AR correct, after that I call remove procedure to drop some partitions.
I see the error when insert into View A: ORA-00600: internal error code, arguments: [kksfbc-reparse-infinite-loop], [], [], [], [], [], [], [])

Some one help me to fix this bug.

Thanks
Re: ORA-00600: internal error code [message #154207 is a reply to message #154170] Fri, 06 January 2006 04:22 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Point your browser to Metalink. There is a ORA-600 lookup tool. I think you are hitting bug #2626347.
Anyway, some version information (database, os) is indispensable in case of an internal error.

MHE
icon7.gif  Re: ORA-00600: internal error code [message #359201 is a reply to message #154170] Fri, 14 November 2008 02:02 Go to previous messageGo to next message
rizimazhar
Messages: 34
Registered: August 2008
Location: Pakistan
Member

Error
ORA-00600: internal error code, arguments: [kcratr1_lostwrt]....bla bla

You can try for the following command if alert_log shows only the above error in alert log file;

> connect sys as sysdba
>
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> RECOVER DATABAES;
SQL> ALTER DATABSE OPEN;

-- database opened.

SQL>
I hope it works fine
Re: ORA-00600: internal error code [message #359214 is a reply to message #359201] Fri, 14 November 2008 03:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the relation bewteen the problem and you solution?
Or is it a generic answer you give for all ORA-600 error?

Regards
Michel
Re: ORA-00600: internal error code [message #359258 is a reply to message #359214] Fri, 14 November 2008 07:32 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I have to say that the best advice for an ORA-600 is :Metalink
Previous Topic: DELETE
Next Topic: CONNECT BY NOCYCLE gives different results
Goto Forum:
  


Current Time: Sat Dec 03 10:22:04 CST 2016

Total time taken to generate the page: 0.04851 seconds