Geek asks and answers

How to determine what to use Oracle Spatial?

We have an installation of Oracle Enterprise Edition 10 and, as our database administrators have explained to me, Oracle Enterprise installations include all the extensions, and you are simply licensed by what you use.

We found that we use Oracle Spatial, but we do not want to be. I can confirm that it is used with this SQL:

select * from dba_feature_usage_statistics;

Unfortunately, all I can find out. We have a large number of applications that use Spatial elements, but, turning to all our suppliers, they assure us that their applications use the Oracle Locator (which is a free subset of Spatial).

So my question is simple - how do I know which application is using the Oracle Spatial extension? As an alternative (found out with ik_zelf answer), how can I prove that I only use the Locator Spatial Locator locator.

+3
source share
2 answers

Check sdo metadata:

select * from mdsys.sdo_geom_metadata_table where sdo_owner not in ('MDSYS', 'OE')

when you dig a little deeper into dba_feature_usage_statistics, you will find this query as part of determining what is used and what is not. Schema MDSYS and OE are not taken into account, even if they have sdo objects.

+2
source

, Oracle Spatial Oracle Locator - Oracle: http://docs.oracle.com/cd/B19306_01/appdev.102/b14255/sdo_locator.htm#SPATL340 - , , Oracle Spatial.

, ( ) Locator :

  • GeoRaster
  • Geocoding
  • sdo_geom

, , , sdo_util, . dba_source , .

, , - , , Oracle.

0

More articles:


All Articles