Create index

SQL> SELECT 1 FROM dual WHERE jc_contains('CN1C=NC2=C1C(=O)N(C)C(=O)N2C', 'CN1C=NC2=C1C(=O)N(C)C(=O)


N2C') = 1;





1


----------


1





SQL>








select * from jctable t


WHERE jc_contains(t.cd_smiles, 'CCCC(C)C1(CC=C)C(=O)NC(=O)NC1=O') = 1;








raise_application_error(-20101,


'Please, create domain index on the column referenced in the operator '


|| func_name || ' of the table with DATA_OBJECT_ID=' || dobject_id


|| '. You can find out the name of the table by executing:


SELECT owner, object_name INTO schema_name, table_name


FROM sys.dba_objects WHERE DATA_OBJECT_ID = ' || dobject_id);














oracle@oraita:~/jchem/cartridge> cd /home/oracle/jchem/cartridge





oracle@oraita:~/jchem/cartridge> ./test.sh gvop/gvop@ov10











SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 18 17:01:00 2007











Copyright (c) 1982, 2005, Oracle. All rights reserved.











Enter user-name:





Connected to:





Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production





With the Partitioning, OLAP and Data Mining options











SQL>





JCHEM_CORE_PKG.GETENVIRONMENT()





--------------------------------------------------------------------------------





Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi





PL/SQL Release 10.2.0.1.0 - Production





CORE 10.2.0.1.0 Production





TNS for Linux IA64: Version 10.2.0.1.0 - Production





NLSRTL Version 10.2.0.1.0 - Production





NLSRTL Version 10.2.0.1.0 - Production





JChem version in the database: 3.2.4





JChem version in the Tomcat server: 3.2.4





java.vm.version: 1.4.2_04-b05





java.vm.vendor: Sun Microsystems Inc.





Apache Tomcat/5.0.19











JCHEM_CORE_PKG.GETENVIRONMENT()





--------------------------------------------------------------------------------





Major JDBC version in Tomcat: 10





Minor JDBC version in Tomcat: 2

















Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production





With the Partitioning, OLAP and Data Mining options


oracle@oraita:~/jchem/cartridge>

















SQL*Plus: Release 10.2.0.1.0 - Production on Cs. Júl. 19 11:34:39 2007





Copyright (c) 1982, 2005, Oracle. All rights reserved.








Kapcsolódási cél:


Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production


With the Partitioning, OLAP and Data Mining options





SQL> SELECT owner, object_name


2 --INTO schema_name, table_name


3 FROM sys.dba_objects WHERE DATA_OBJECT_ID = 286267;





OWNER


------------------------------


OBJECT_NAME


--------------------------------------------------------------------------------


GVOP


JCTABLE

When creating a jc_idxtype index on a JChem table, you have to use the same jchemproperties table as the one which you used for creating the same JChem table.





If you created the table using the JChemManager GUI, the jchemproperties table had to be specified as part of the connection properties during connect. Specify this same jchemproperties table for the jc_idxtype index using the JChemPropertiesTable index parameter (http://www.chemaxon.com/jchem/doc/guide/cartridge/index.html#index)





(By default, the jc_idxtype index will use the jchemproperties table found in the schema where the index is created. If none is found, one will be created.)





P.