unable to create spatial index via dynamic

From: Narender Akula <narender.akula_at_terralinkltd.com>
Date: Mon, 14 May 2001 21:57:25 -0700
Message-ID: <F001.003033A6.20010514214520@fatcity.com>

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).

Received on Mon May 14 2001 - 23:57:25 CDT

unable to create spatial index via dynamic_sql