Re: spatial on 10g...

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 17 Nov 2005 08:52:07 GMT
Message-ID: <1132217523.262433@proxy.dienste.wien.at>

Volker Hetzer <volker.hetzer_at_ieee.org> wrote:
> 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.

I get the following response on 10.2.0.1.0:

create index TST_PARTS_IDX1 on TST_PARTS(BZP) indextype is mdsys.spatial_index parameters ('layer_gtype=POLYGON')

                               *

ERROR at line 1:
ORA-29918: cannot create domain indexes on temporary tables

Yours,
Laurenz Albe Received on Thu Nov 17 2005 - 02:52:07 CST