| ORA-00600: internal error code [message #154170] |
Fri, 06 January 2006 01:47  |
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
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
