Hi Andrea, Mark
an update to this
just installed geoserver on my home laptop, with oracle plugin.
later, log in into oracle as sysdba and create new user
CREATE USER tst IDENTIFIED BY tst
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP";
GRANT CREATE TABLE TO tst ;
GRANT CREATE VIEW TO tst ;
GRANT CREATE SESSION TO tst ;
GRANT ALTER SESSION TO tst ;
grant SELECT on "MAPDATA"."STREET" to "TST" ;
as the new user:
CREATE OR REPLACE VIEW STR AS SELECT * FROM MAPDATA.STREET
next step is not necessarry, though...
INSERT INTO USER_SDO_GEOM_METADATA
VALUES (
'STREET', -- table/view name
'GEOLOC', -- geom column
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT('X', 0, 400000, 0.001), -- minX, maxX, toleranceY
MDSYS.SDO_DIM_ELEMENT('Y', 0, 400000, 0.001) -- minY, maxY, toleranceY
),
123456 --your CS
);
and configure on geoserver site all you need
If someone can update docs with this - you are welcome
if not - i'll try to do that by the end of the week
regards, michael
On Thu, Mar 1, 2012 at 6:23 PM, Andrea Aime <[email protected]>wrote:
> On Thu, Mar 1, 2012 at 4:56 PM, Mark Hammond <[email protected]> wrote:
> > Is there a definitive list anywhere? (Would be jolly useful addition to
> > GeoServer Oracle Plugin documentation)
>
> We don't have one, the list of stuff that the store tries to access
> actually grew
> over time.
>
> First off, we basically use everything powering jdbc metadata, which should
> be the "dictionary" for tables and indexes.
> And then all other accesses are done using this class:
>
>
> http://svn.osgeo.org/geotools/trunk/modules/plugin/jdbc/jdbc-oracle/src/main/java/org/geotools/data/oracle/OracleDialect.java
>
> It would indeed be nice if someone put toghether a patch for the
> documentation
>
> Cheers
> Andrea
>
> --
> -------------------------------------------------------
> Ing. Andrea Aime
> GeoSolutions S.A.S.
> Tech lead
>
> Via Poggio alle Viti 1187
> 55054 Massarosa (LU)
> Italy
>
> phone: +39 0584 962313
> fax: +39 0584 962313
> mob: +39 339 8844549
>
> http://www.geo-solutions.it
> http://geo-solutions.blogspot.com/
> http://www.youtube.com/user/GeoSolutionsIT
> http://www.linkedin.com/in/andreaaime
> http://twitter.com/geowolf
>
> -------------------------------------------------------
>
>
> ------------------------------------------------------------------------------
> Virtualization & Cloud Management Using Capacity Planning
> Cloud computing makes use of virtualization - but cloud computing
> also focuses on allowing computing to be delivered as a service.
> http://www.accelacomm.com/jaw/sfnl/114/51521223/
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
