OraFAQ Forum: Server Administration » ORA-00600 internal error while creating index

Home » RDBMS Server » Server Administration » ORA-00600 internal error while creating index

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00600 internal error while creating index [message #55689]

Sat, 08 February 2003 21:17

Taehun Yoon
Messages: 1
Registered: February 2003

Junior Member

Hello,

I created a spatial table with the statement below;

create table tb_lidar_point_spatial(
spot MDSYS.SDO_GEOMETRY not null,
pulse number,
laser number,
);

After creating the table, I inserted records something like this;

insert into tb_lidar_point_spatial(spot, pulse, laser)
values(
MDSYS.SDO_GEOMETRY(2001, NULL,
MDSYS.SDO_POINT_TYPE(100, 200, 100),
NULL, NULL),
11, 21);

After I inserted points, I inserted a meta data;

INSERT INTO USER_SDO_GEOM_METADATA
VALUES(
'tb_lidar_point_spatial',
'spot',
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT('X',
-1000000000000, 1000000000000, 1),
MDSYS.SDO_DIM_ELEMENT('Y',
-1000000000000, 1000000000000, 1)
),
NULL
);

Until now, I succeeded. But when I tried to create index, I failed. The statement I used is;

CREATE INDEX idx_lidar_point_spatial ON tb_lidar_point_spatial(spot)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS('
sdo_level=0
layer_gtype=POINT
sdo_indx_dims=2
');

When I executed this, error occurred.

CREATE INDEX idx_lidar_point_spatial ON tb_lidar_point_spatial(spot)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [[mdidxrbd]]
ORA-13249: Error in Spatial index: index build failed
ORA-13249: Error in spatial index: [[mdrcrtxfergm]]
ORA-13249: Error in spatial index: [[mdpridxtxfergm]]
ORA-29400: data cartridge error
ORA-00600: internal error code, arguments: [[kcbnew_3]], [[1]], [[]], [[]], [[]], [[]], [[]],
[[]]
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 7
ORA-06512: at line 1

What did I wrong? Even though, a point has X, Y, Z values, but I need to index only 2 dimension because I need to use SDO_RELATE function. Please help!!!

By the way, could you tell me where I can find the trace file? I am using Oracle 9i and Windows XP.

Report message to a moderator

Re: ORA-00600 internal error while creating index [message #55701 is a reply to message #55689]

Mon, 10 February 2003 23:13

Trifon Anguelov
Messages: 514
Registered: June 2002

Senior Member

I suggest you review this Metalink Note:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=1058792.6

It explains why this error is happening and how to fix it.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

The latest Oracle DBA forums

Report message to a moderator

Previous Topic:	Index Extents
Next Topic:	statspack rpt_latch.sql "dlm resource hash list"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:51:48 CDT 2024