spatial on 10g...

Giganews Newsgroups
Subject: spatial on 10g...
Posted by:  Volker Hetzer (volker.hetz…@ieee.org)
Date: Wed, 16 Nov 2005

Hi!
Does somebody have spatial running on 10g and can try the following script for me?

create global temporary table TST_PARTS
    (
    REFDes varchar(10) not null,
    BZP mdsys.sdo_geometry not null,
    primary key (REFDes)
    );
insert into USER_SDO_GEOM_METADATA
        (table_name, column_name,diminfo,srid)
    values
        (
        'TST_PARTS',
        'BZP',
         MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',-1000,1000,0.00001),MDSYS.SDO_DIM_ELEMENT('Y',-1000,1000,0.00001)),
         NULL
         );
create index TST_PARTS_IDX1 on TST_PARTS(BZP) indextype is mdsys.spatial_index parameters ('layer_gtype=POLYGON');

9i gives me an error saying that it can't handle varrays or nested tables in temporary tables
and I'd like to know whether either it can now or spatial works around it somehow.

Lots of Greetings and thanks!
Volker

Replies