Error when creating index

User 0b9f41d1f6

01-09-2005 14:00:53

Hello,





I am trying to create index in ORACLE 10g for structure table (CREATE INDEX TESTUNIQ_CD_SMILES_IDX ON TESTUNIQ(cd_smiles) INDEXTYPE is jc_idxtype PARAMETERS('TABLESPACE=TEST_INDEX') , but it give me the following error:





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.IllegalArgumentException: The TABLESPACE parameter can not be


specified with JChem tables


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


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





Most strange thing that it looks like index was created.





We using jchem 3.0.13





What am I doing wrong? Thanks for info/advice.

ChemAxon aa7c50abf8

01-09-2005 14:34:32

TESTUNIQ is most probably a JChem table.





The TABLESPACE index parameter for jc_idxtype is used to specify in which table space the index table has to be created. In case of JChem tables, there is no index table. The information used by the jc_idxtype operations are stored in the base table (JChem table) itself. If you have any preferences regarding the tablespace to use, you have to specify it as part of the table creation. For example, if you create the table with JChemManager, the jcman GUI allows you at some point to review the SQL statement that will be used to create the table. You can edit this statement to include the required storage options.