The schema acd3d20083 must be empty, 5.2

hi,

  how can i use exist schema when install cartridge5.2?

 thanks.

Hi

You cannot. You have to install JChem Cartridge in an empty schema. You can then configure your existing users (schemata) to use the JChem Cartridge installation following this description: http://www.chemaxon.com/jchem/doc/admin/cartridge.html#users .

hi, pkovacs

when i install cartridge, i set the cartrigde owner is "jchem", but i want to use "acd3d20083" to access cartridge, when i run my application, it ask me to create domain index, how can i create domain index for acd3d20083?

create index acd3d20083.acd1_structure_smiles on acd3d20083.acd1_structure(cd_smiles) indextype is acd3d20083.jc_idxtype;

this is wrong, it return jc_idxtype is not exist.

thanks

If you installed JChem Cartridge in the JCHEM schema, the jc_idxtype can be found there. The statement to create the index is therefore:

create index acd3d20083.acd1_structure_smiles on acd3d20083.acd1_structure(cd_smiles) indextype is jchem.jc_idxtype;

create index acd3d20083.acd1_structure_smiles on acd3d20083.acd1_structure(cd_smiles) indextype is jchem.jc_idxtype;

i try it, but fail, the attachment is screenshot.

create index acd3d20083.acd1_structure_smiles on acd3d20083.acd1_structure(cd_smiles) indextype is jchem.jc_idxtype;

i use jchemmanager to update structure tables, and then i run above code,it return error again.

I have solved this problem, thanks!