Unquoted Oracle identifiers are converted to uppercase; this may be
significant in USER_SDO_GEOM_METADATA values, as lowercase string values
(table and column names) will not match.
Kind regards,
Ben.
On 19/11/13 21:09, rkliao wrote:
> Thanks for the reply.
>
> I have figured out the problem. It had to do with the creation of an entry
> in the ORACLE USER_SDO_GEOM_METADATA table in order to create the Spatial
> index.
>
> I originally set it to the ff (copied this off the web as I was not able to
> create spatial indexes without it):
>
> INSERT INTO USER_SDO_GEOM_METADATA
> VALUES (
> 'Geoserver_Cem000',
> 'the_geom',
> MDSYS.SDO_DIM_ARRAY( -- 20X20 grid, virtually zero tolerance
> MDSYS.SDO_DIM_ELEMENT('X', 0, 20, 0.005),
> MDSYS.SDO_DIM_ELEMENT('Y', 0, 20, 0.005)
> ),
> 4326 -- SRID
> );
>
> and have changed it to
>
> INSERT INTO USER_SDO_GEOM_METADATA
> VALUES (
> 'GEOSERVER_CEMDATA',
> 'THE_GEOM',
> MDSYS.SDO_DIM_ARRAY(
> MDSYS.SDO_DIM_ELEMENT('X', -180, 180, 0.005),
> MDSYS.SDO_DIM_ELEMENT('Y', -90, 90, 0.005)
> ),
> 4326 -- SRID
> );
>
>
> I am very new to Oracle spatial and am learning as I go. I am not even sure
> why the difference but it worked.
>
> Thank you for the reply.
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/Oracle-Data-in-Geoserver-tp5089732p5089877.html
> Sent from the GeoServer - User mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Shape the Mobile Experience: Free Subscription
> Software experts and developers: Be at the forefront of tech innovation.
> Intel(R) Software Adrenaline delivers strategic insight and game-changing
> conversations that shape the rapidly evolving mobile landscape. Sign up now.
> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
--
Ben Caradoc-Davies <ben.caradoc-dav...@csiro.au>
Software Engineer
CSIRO Earth Science and Resource Engineering
Australian Resources Research Centre
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
