Difficulty creating JChem Index on test instance of database

Hi,

We are doing some testing on the cartridge in a copy of the production instance of the database, and we can't seem to drop and recreate a jcart index.

we:

1). Dropped the index "jc_idx".

2). Got an error on index creation saying that the object already existed.  Figured out this was supporting tables.

3). manually dropped the tables "jc_idx_udop" "jc_idx_property" and  "jcart.jc_idx_udop", "jcart.jc_idx_property"

4). Ran the below anonymous block:

5) got the error in the attached screen capture.

DECLARE
 
   err_msg varchar2(4000);
 
BEGIN
       SYS.dbms_system.ksdwrt(2,'dropping jc_idx');
 
       begin
         execute immediate 'drop index jc_idx'; commit;
       exception
          when others then
                sys.dbms_system.ksdwrt(2,'drop failed');
       end;
 
       SYS.dbms_system.ksdwrt(2,'creating jc_idx');
 
 
        EXECUTE IMMEDIATE 'CREATE INDEX jc_idx ON structure(s_smiles) INDEXTYPE IS jchem.JC_IDXTYPE PARAMETERS(''TABLESPACE=structure_indexes,tdf=y,haltOnError=nf'')';
 
        SYS.dbms_system.ksdwrt(2,'granting jc_idx');
 
        jchem.privman_pkg.grants_on_jcidx('PUBLIC', 'SENOBASE', 'JC_IDX', 1, 1, 1, 1);
 
        commit;
 
        SYS.dbms_system.ksdwrt(2,'done with jc_idx'); exception
        when others then
 
        err_msg := SUBSTR(SQLERRM,1,4000);
 
        SYS.dbms_system.ksdwrt(2,'jc_idx failed with:' || err_msg);
 
end;
/

 

Unfortunately, it is not possible to copy and gain a working instance of jchem oracle cartridge.

We recommend

1. to install a new instance of the JChem Oracle Cartridge


2. to copy only the tables containing the chemical structures from the production system to the new schema


3. to create jc_idxtype indexes

Krisztina