Difficulty creating JChem Index on test instance of database

User 7f33ec9a5c

11-02-2016 18:16:44

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;
/

 

ChemAxon abe887c64e

12-02-2016 13:06:47

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