Oracle 11g Standard Edition and Spatial queries...
Hi All,
We have a specific instance running Oracle Standard edition 11g.
If I look at dba_registry, it shows following:
COMP_ID | SDO |
COMP_NAME | Spatial |
VERSION | 11.2.0.1.0 |
STATUS | OPTION OFF |
MODIFIED | 8/15/2009 0:50 |
NAMESPACE | SERVER |
CONTROL | SYS |
SCHEMA | MDSYS |
PROCEDURE | VALIDATE_SDO |
STARTUP | |
PARENT_ID | |
OTHER_SCHEMAS |
I was hoping all spatial functionality and feature will not be installed and not available at all.
But I can still do "describe sdo_geom" and do sample query with the package.
SELECT sdo_geom.sdo_distance ( sdo_geom.sdo_geometry(2001 ,8307 ,sdo_geom.sdo_point_type(40.716715, -74.033907 , NULL) ,NULL ,NULL), sdo_geom.sdo_geometry(2001 ,8307 ,sdo_point_type(40.716300,-74.033901, NULL) ,NULL ,NULL), 0.0001, 'unit=M' ) distance_in_mfrom DUAL;