Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Locator/Spatial

Re: Oracle Locator/Spatial

From: Robbert van der Hoorn <removetheXinR.Xvanderhoorn_at_osait.nl>
Date: Mon, 17 Jul 2006 10:47:26 +0200
Message-ID: <44bb4fcb$0$31637$e4fe514c@news.xs4all.nl>


<z1hou1_at_gmail.com> wrote in message
news:1153050126.070540.274980_at_m73g2000cwd.googlegroups.com...
> Hi,
> How do I know that Oracle Locator is installed on an instance of Oracle
> 10gR2. I understand that Oracle Locator is an integral part of the
> 10gR2 install while Spatial is a priced option. I tried to create a
> table with the type SDO_GEOMETRY, but there was no such type. Does this
> mean that Oracle Locator is not installed, or that I do not have rights
> to these types?
>
> Thanks for your help.
>
> Regards,
> z1hou1
>

  1. Check if youy have a user MDSYS in your database (if you have, locator should be there)
  2. Check if you can use MDSYS.SDO_GEOMETRY in stead of SDO_GEOMETRY.

Robbert Received on Mon Jul 17 2006 - 03:47:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US