Does anyone have an example of creating a primary key on an oracle view?
I use this
CREATE OR REPLACE FORCE VIEW person_pk_view
(GEOM, RecievedTime,NAME,IntVal,SHAPE
UNIQUE RELY DISABLE NOVALIDATE,CONSTRAINT pk_person_view PRIMARY KEY
(GEOM) RELY DISABLE NOVALIDATE)
AS
SELECT ORA_POLY_POINTS.ID,
ORA_POLY_POINTS.NAME,
ORA_POLY_POINTS.intval,
ORA_POLY_POINTS.RECEIVED_DATETIME,
ORA_POLY_POINTS.SHAPE
FROM ORA_POLY_POINTS;
Where ORA_POLY_POINTS.SHAPE is of type SDO_GEOMETRY but oracle give me
an error ORA-02329.
Thx. in advance
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users