Hi, yes I figured that out, for now I just drop the index added initialy and I append new data to the table, though I`m not very optimistic about not getting any more trouble when publish this table in geoserver.
regards, Imran On Wed, Aug 11, 2010 at 11:25 AM, Peter J Halls <[email protected]> wrote: > Imran, > > in the documentation for the OCI Driver it says clearly that the spatial > extent and SDO_GEOM_METADATA entries are not updated when using append mode > and that it is up to the caller to manage these. > > It is actually quite easy to code for this, but does require an SQLExecute > to handle SDO_GEOM_METADATA. I simply generate this on the fly, along with > the SQL to update the spatial index. > > Best wishes, > > Peter > > Imran Rajjad wrote: >> >> Hi list, >> >> I inserted a shape file in oracle 11g, now I have another shape file >> with exactly same attributes, I`m using the -append option but it >> seems the new shapefile wont get appended to the table, there seems to >> be some problem related to the spatial index because data in both >> shape files does not come under same spatial extent, is there anyway >> to tell gdal not to create spatial index when data is being inserted >> and when all the data has been inserted we create the spatial index >> manualy? >> >> regards, >> Imran >> >> >> > > -- > -------------------------------------------------------------------------------- > Peter J Halls, GIS Advisor, University of York > Telephone: 01904 433806 Fax: 01904 433740 > Snail mail: IT Services, University of York, Heslington, York YO10 5DD > This message has the status of a private and personal communication > -------------------------------------------------------------------------------- > -- I.R _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
