Sorry, figured it out.....
For those interested
CREATE OR REPLACE FORCE VIEW person_pk_view
(ID,NAME,IntVal,RCVDTIME,SHAPE,CONSTRAINT pk_person_view PRIMARY KEY
(ID) 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;
________________________________
From: [email protected]
[mailto:[email protected]] On Behalf Of
Gorman, Stephen A.
Sent: Wednesday, December 15, 2010 1:08 PM
To: [email protected]
Subject: [Geoserver-users] Example Primary Key on Oracle view?
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
