Re: Oracle8i SDO_GEOM_METADATA table not found?

From: <jwkeene_at_my-deja.com>
Date: Wed, 14 Jul 1999 17:12:43 GMT
Message-ID: <7migdv$m3r$1@nnrp1.deja.com>

You need to create the SDO_GEOM_METADATA table in your own schema. Syntax should be as follows:

create table SDO_GEOM_METADATA (

   TABLE_NAME VARCHAR2(30),
   COLUMN_NAME VARCHAR2(30),
   DIMINFO MDSYS.SDO_DIM_ARRAY
)

One column needs to be inserted into SDO_GEOM_METADATA for each table and column you want to index.

Example:

insert into SDO_GEOM_METADATA
values
(

     'MY_SPATIAL_TABLE',
     'MY_SPATIAL_COLUMN',
     MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',-180,180,0),
                         MDSYS.SDO_DIM_ELEMENT('Y',-90,90,0))

);

Hope this helps. Good Luck!

In article <378C69D7.F67B9ED1_at_hotmail.com>, "J.D. Carter" <jd_carter_at_hotmail.com> wrote:
>
> I attempted to create an index on a MDSYS.SDO_GEOMETRY field and
> received the following error. Can someone guide me to the create
> SDO_GEOM_METADATA table SQL script?
>
> Thank you.
> ---------------------------------------------------------------------
> ERROR at line 1:
> ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
> ORA-13203: failed to read SDO_GEOM_METADATA table
> ORA-29400: data cartridge error
> ORA-00942: table or view does not exist
> ORA-06512: at "MDSYS.SDO_INDEX_METHOD", line 7
> ORA-06512: at line 1
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 14 1999 - 12:12:43 CDT