change type of cd_structure

Hi.


I've installed Jchem 3.0.12 and created a strucutre table using JChemManager.


My database is Oracle 9.2.0.6





I discovered that the column cd_structure is of type long raw.


Oracle does not support replication of long raw, you have to use blob.


Are you going to change the type of cd_structure, or can I change it through sqlplus ?





/Mikael

You can change it through sqlplus:

Code:

alter table <your-jchem-table> modify(cd_structure blob)

With JChem version 3.1, the default type for cd_structure is BLOB (instead of LONG RAW).





Peter

Hi,





For new tables you can also change the type in the table creation dialog by editing the CREATE TABLE statement.





Actually BLOB will be the default type only from JChem 3.1, but current versions can also use it.


We also support CLOB for cd_structure, but it may have some impact on import performance on certain systems.





Best regards,





Szilard

Hi.


No, default for cd_structure in 3.0.13 is still long raw !

Sorry!





BLOB will be the default beginning with JChem 3.1.