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: [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: Nicoll, Iain (Calanais)
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).
