hello to change or set the projection null, I think you need to modify user_sdo_geom_metadata, there is a SRID column in it.
secondly you should try creating spatial index with default values for starters. regards, Imran On Mon, Oct 11, 2010 at 2:21 PM, 王震阳 <[email protected]> wrote: > Hello, > > I have two questions: > 1. I have some data in Oracle Spatial, but I can't see these tables from > GeoServer when I try to add this layer. Finally I think this is because > GeoServer can't handle the tablenames starting with "SDO" because I can see > other tables with other table names. > 2. I import some data by Manifold 8, but I can't display the data correctly. > The line features are displayed as points. I have created spatial index by > the following script: > ---- > CREATE INDEX LINK_COPY_spatial_idx > ON LINK_COPY(geom) > iNDEXTYPE IS MDSYS.SPATIAL_INDEX > PARAMETERS ('layer_gtype=LINE'); > ---- > I think this may because of the SDO_SRID value in > mdsys.sdo_geom_metadata_table because I can correctly display data imported > by shp2sdo and these data has null in mdsys.sdo_geom_metadata_table.SDO_SRID > column. > > Then I just update the value of mdsys.sdo_geom_metadata_table.SDO_SRID to > null, but when I try to create a spatial index, I receive:ORA-13365: layer > SRID does not match geometry SRID. > > Does anybody know how to put the projection in oracle to null? > > > Regards, > Wang Zhenyang > > ------------------------------------------------------------------------------ > Beautiful is writing same markup. Internet Explorer 9 supports > standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3. > Spend less time writing and rewriting code and more time creating great > experiences on the web. Be a part of the beta today. > http://p.sf.net/sfu/beautyoftheweb > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > -- I.R ------------------------------------------------------------------------------ Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3. Spend less time writing and rewriting code and more time creating great experiences on the web. Be a part of the beta today. http://p.sf.net/sfu/beautyoftheweb _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
