Oracle Spatial Question

From: Patrick Jones <plj_at_mitre.org>
Date: 2000/03/21
Message-ID: <38D7C3F8.2E0F1B58@mitre.org>#1/1

Howdy,

        I'm having trouble with my 1st attempt at Oracle Spatial. Below is the script I run. The select statement gives me the following error:

select s.NAME from SMALL s
*
ERROR at line 1:

ORA-29902: error in executing ODCIIndexStart() routine
ORA-13211: failed to tessellate the window object
ORA-13208: internal error  while evaluating

[TOO_MANY_TILES_FOR_WINDOW_OBJECT] operator

ORA-13213: failed to generate spatial index for window object
ORA-13213: failed to generate spatial index for window object
ORA-06512: at "MDSYS.SDO_INDEX_METHOD", line 73
ORA-06512: at line 1

	What am I doing wrong?

Thanx,

Pat Jones
plj_at_mitre.org

---

drop table SMALL;

create table SMALL (

	NAME                 VARCHAR2(255),
	PLACE                MDSYS.SDO_GEOMETRY

);

insert into SMALL VALUES(

	'TheName', 
	MDSYS.SDO_GEOMETRY(1,NULL,MDSYS.SDO_POINT_TYPE(
		 -86.54991944444444,30.46041111111111,NULL), NULL, NULL)

);

DELETE from sdo_geom_metadata where TABLE_NAME = 'SMALL';

INSERT INTO sdo_geom_metadata VALUES
('SMALL',
'PLACE',

MDSYS.SDO_DIM_ARRAY(

	MDSYS.SDO_DIM_ELEMENT('Long', -180, 180, .005),
	MDSYS.SDO_DIM_ELEMENT('Lat', -90, 90,    .005)

));

drop index PLACEIND FORCE;
create index PLACEIND on SMALL(PLACE) indextype is MDSYS.SPATIAL_INDEX PARAMETERS(
'SDO_LEVEL = 12, SDO_NUMTILES = 1');
select s.NAME from SMALL s
where mdsys.sdo_filter(

	s.PLACE,
 	mdsys.sdo_geometry(3,null,null,
	mdsys.sdo_elem_info_array(1,3,3),
	mdsys.sdo_ordinate_array(-120,25,-70,50)),
	'querytype=window layer_gtype=POINT') = 'TRUE';

commit; Received on Tue Mar 21 2000 - 00:00:00 CST