Is the user executing the procedure the same user who owns the table for which the
index is intended?
>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).