SDO_GEOMETRY methods available in XE?
986923Jan 24 2013 — edited Jan 24 2013Hi,
I'm trying to port my PostGIS db-structure to Oracle. The following SQL command:
CREATE TABLE geomtest (
gid NUMBER PRIMARY KEY,
geom SDO_GEOMETRY,
CONSTRAINT enforce_dims_geom CHECK (geom.GET_DIMS() = 2)
);
produces the following error:
ORA-00904: "GEOM"."GET_DIMS": invalid identifier
Does the express edition include SDO_GEOMETRY methods?
best regards,
Georg