RE: unable to create spatial index via dynamic

From: Nicoll, Iain (Calanais) <iain.nicoll_at_calanais.com>
Date: Tue, 15 May 2001 01:44:37 -0700
Message-ID: <F001.003034BC.20010515004548@fatcity.com>

May be like the reply to your previous question in that you may be able to create an index through a role from sqlplus but from pl/sql the privilege has to be granted directly to the user.

Cheers

Iain

-----Original Message-----
Sent: 15 May 2001 06:45
To: Multiple recipients of list ORACLE-L

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: Nicoll, Iain (Calanais)
  INET: iain.nicoll_at_calanais.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 Tue May 15 2001 - 03:44:37 CDT

RE: unable to create spatial index via dynamic_sql