, 2010 1:08 PM
To: geoserver-users@lists.sourceforge.net
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
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_POINT