Re: unable to create spatial index via dynamic_sql

From: Tim Sawmiller <sawmillert_at_state.mi.us>
Date: Tue, 15 May 2001 04:55:20 -0700
Message-ID: <F001.00303737.20010515044116@fatcity.com>

Is the user executing the procedure the same user who owns the table for which the index is intended?

>>> narender.akula_at_terralinkltd.com 05/15/01 01:45AM >>> hi list,
I am able to create index from Sqlplus as... create index i_sptl_test on ADDRESSED_PROPERTY_(polygon_geometry) indextype is
mdsys.spatial_index;
Thisstatement works fine and I ma able to create index. But the same statement when executing through package - procedure p_crt_sptl_index ( it fails....
listed error messages. Of course by using Dynamic Sql. DDL Statement: create index i_sptl_test on ADDRESSED_PROPERTY_(polygon_geometry)
DDL Statement: indextype is mdsys.spatial_index DDL Statement:
** Fatal Exception p_crt_sptl_index**
ORA-29855: error occurred in the execution of ODCIINDEXCREATEroutine ORA-13231: failed to create
index table [Create index table failed forI_SPTL_TEST_rt$] during R-tree creation

ORA-29400: data cartridge error
ORA-01031: insufficient privileges
ORA-010

** Fatal Exception incrt_metadata_entries **

*** p_crt_sptl_indexes: creation of SpatialIndex on 
ADDRESSED_PROPERTY_.polygon_geometry
via p_crt_sptl_index failed ***

Anybody got ideas why....
this is Oracle Saptial database 8.1.7 on sunsparc solaris 7.

> narender.akula
> http://www.terralinkltd.com
> Oracle DBA, Terralink Limited
> Wellington, NZ.
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Narender Akula
  INET: narender.akula_at_terralinkltd.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Sawmiller
  INET: sawmillert_at_state.mi.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue May 15 2001 - 06:55:20 CDT