Oracle 8 Server Spatial Cartrigde
From: Sandor Rapolder <srapolde_at_igd.fhg.de>
Date: Fri, 10 Jul 1998 12:41:47 +0200
Message-ID: <35A5EFEB.A99841AE_at_igd.fhg.de>
[Quoted] Has enyone experience with the satial data cartidge.
we used the following command:
Date: Fri, 10 Jul 1998 12:41:47 +0200
Message-ID: <35A5EFEB.A99841AE_at_igd.fhg.de>
[Quoted] 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);
But always got the following message:
SQL> execute sdo_admin.populate_index('forrests' , 4); begin sdo_admin.populate_index('forrests' , 4); end;
*
FEHLER in Zeile 1:
ORA-20000: ORA-13010 encountered ORA-06512: in "MDSYS.MDLIB", Zeile 68 ORA-06512: in "MDSYS.SDO_ADMIN", Zeile 227 ORA-06512: in Zeile 1
[Quoted] No values were added to the XX_SDOINDEX table.
Has anyone experienced the same problem or has an idea how to solve it. We are very gratefull for any help Received on Fri Jul 10 1998 - 12:41:47 CEST