Domain index on a clob result in ORA-1031

Hi.


Trying to create a domain index of jchem.jc_idxtype on a clob column results in ORA-1031.





SQL> desc temp;


Name Null? Type


----------------------------------------- -------- ----------------------------


COMPOUND_ID VARCHAR2(50)


MOLFILE CLOB





SQL> create index idx_temp_molfile on temp(molfile) indextype is jchem.jc_idxtype;


create index idx_temp_molfile on temp(molfile) indextype is jchem.jc_idxtype


*


ERROR at line 1:


ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine


ORA-29532: Java call terminated by uncaught Java exception:


java.lang.Exception: The following exception has been thrown by the servlet:


Exception: ORA-01031: insufficient privileges


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 0


ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 16





Why ?


/Mikael

A general remark: JChem Cartridge currently supports VARCHAR2 and BLOB columns. Although you should be able to create a jc_idxtype index on a CLOB column, JChem Cartridge does not currently provide operators for CLOB columns. So it does not really make sense to create jc_idxtype index on CLOB columns.





I am just curious: Do you currently store your chemical structure in CLOB columns? Do you have a particular reason to prefer CLOB to BLOB?





Please, could you post the relevant portion from <tomcat-home>/logs/catalina.out (that with the Java stack trace)?





Is creating index on VARCHAR2 columns successful?





Peter