Re: Oracle 8 Server Spatial Cartrigde
Date: Wed, 15 Jul 1998 20:26:54 GMT
Message-ID: <ig8r1.6409$%O4.2068904_at_news.tpnet.pl>
Sandor Rapolder wrote in message <35A5EFEB.A99841AE_at_igd.fhg.de>...
>Has enyone experience with the satial data cartidge.
>Our problem is how to create an index for the SDO layer.
>An index usually in generated by the command SDO_ADMIN.POPULATE_INDEX.
>As the manual says This will fill the table XX_SDOINDEX.
>We created a sample database as it is discribed in the manual. First we
>created the tables XX_SDOLAYER, XX_SDODIM, XX_SDOGEOM AND XX_SDOINDEX.
>After this we inserted some sample values. The manual says that then the
>index has to be created.
>we used the following command:
>
>execute SDO_ADMIN.POPULATE_INDEX('FORRESTS', 4);
I had the same problem, with 7.3.3 SDO
There are two ways to create index ,POPULATE_INDEX calculates index for all
records in layer,
but there is also a procedure calculating index for one GID ( I don't
remeber name of the procedure,
but its described in manual on the same page ), it does work
The second way is recomended for refreshing index after updating small
number of raws
Szymon Kolorz
Hanslik Software Laboratory
Katowice, POLAND
szym_at_polsl.gliwice.pl
Received on Wed Jul 15 1998 - 22:26:54 CEST