Database Administration (MOSC)

MOSC Banner

Oracle 11g Standard Edition and Spatial queries...

edited Dec 3, 2016 4:07PM in Database Administration (MOSC) 5 commentsAnswered ✓

Hi All,

We have a specific instance running Oracle Standard edition 11g.

If I look at dba_registry, it shows following:

COMP_IDSDO
COMP_NAMESpatial
VERSION11.2.0.1.0
STATUSOPTION OFF
MODIFIED8/15/2009 0:50
NAMESPACESERVER
CONTROLSYS
SCHEMAMDSYS
PROCEDUREVALIDATE_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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center