Oracle Spatial Question

Hi All,

I'm using Oracle Spatial Cartridge 8.1.4 Beta for Win NT to implement a spatial query.
But I meet some problem when using it. Here is What I'm doing:

1. create table PARKS( name VARCHAR2(30), geometry SDO_GEOMETRY);
2. create table ROADS( name VARCHAR2(30), geometry SDO_GEOMETRY);
3. Import Data into the tables ROADS and PARKS
4. Create table SDO_GEOM_METADATA

SQL> desc SDO_GEOM_METADATA ;

        Name                                                  Null?
Type
        ----------------------------------------------------- --------

        TABLE_NAME
VARCHAR2(32)
        COLUMN_NAME
VARCHAR2(32)
        DIMINFO
SDO_DIM_ARRAY 5. INSERT INTO SDO_GEOM_METADATA VALUES ('PARKS', 'GEOMETRY',     MDSYS.SDO_DIM_ARRAY( MDSYS.SDO_DIM_ELEMENT('X', 0, 100, 0.005),     MDSYS.SDO_DIM_ELEMENT('Y', 0, 100, 0.005))); 6. Same thing for Table ROADS.
7. CREATE INDEX roads_fixed ON ROADS(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS('SDO_LEVEL = 8'); 8. CREATE INDEX parks_fixed ON PARKS(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS('SDO_LEVEL = 8'); 9. Everything goes ok until here, but When I execute the following query it
gives me an error:

SQL> SELECT A.name
  2 from PARKS A, ROADS B
  3 WHERE mdsys.sdo_filter(A.Geometry, B.Geometry, 'querytype=window') ='TRUE';
SELECT A.name
*
ERROR at line 1:
ORA-03106: fatal two-task communication protocol error

When I execute the same query second time, it prompts me: ERROR at line 2:
ORA-03113: end-of-file on communication channel

And Oracle goes down. What is wrong.
Any help?

Thanks in advance.
Erbug.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 21 2000 - 00:00:00 CDT