Error when creating index with tabletype parameter

Hello!


I tried to create a jc_idxtype index on my oracle table, and i wanted to add a parameter to the index. I got error message.


The environment:

Code:

JCHEM_CORE_PKG.GETENVIRONMENT()            ---------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - Production TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production    JChem version in the database: 3.2.8 JChem version in the Tomcat server: 3.2.8 java.vm.version: 1.6.0_01-b06 java.vm.vendor: Sun Microsystems Inc. Apache Tomcat/6.0.13 Major JDBC version in Tomcat: 10 Minor JDBC version in Tomcat: 2

index creation script:

Code:

CREATE  INDEX SCHEME_IDX ON SCHEMES (SCHEME)         INDEXTYPE IS user.JC_IDXTYPE         PARAMETERS('tableType = reactions');

Error report:

Code:

SQL Error: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-29532: Java call terminated by uncaught Java exception: java.lang.IllegalArgumentException: Illegal option: tableType

"Illegal option: tabltype"Why is it illegal? The index creation goes succesfully without the option. Can anybody help me?





I try to hack it, i create a default index, and owerwrite the tabletype option in the jchemproperties table, but when i want to insert some scheme to the table i got error.

Please, remove the spaces from the index parameter list. They are part of the parameter names and parameter values by default.

oh. really. thx. It was very simple.

Dear Samolyg,





We would like to know more about you and the project you are involved in.


Please provide more information in your profil / company, purpose of use etc.





Thank you in advance,


Nora Lapusnyik