clone a jchem table

Hello





I would like to clone a table however in order to do this I need to be able to update the prop_value_ext column in the jchemproperties table which appears to be of type long raw - this seems to be impossible?


Maybe you know of a way to do this that you can share?


Well I imagine you might say that users should not touch this table, however it seems to be a valid requriement to be able to clone a jchem table.





rename table and oracle export


oracle import


new records in jchemproperties (cannot update prop_value_ext)


regenerate


ensure other associated objects (trigger..etc..)


= table cloned





Many thanks for your help,


Daniel.

Hi Daniel,





Cloning a JChem table:





Create a new JChem table with the same properties as the original has, then:

Code:

insert into <new-table> (select * from <original-table>)

I hope this helps.





Cheers


Peter

You need the relevant data in jchemproperties table I think in order to make it a JCHEM table proper - this is the problem, in that this cannot be replicated easily due to long raw column?





However, in fact we may not need this table to be a JCHEM table as the columns can be indexed all the same as a non-jchem table and this is created with normal export.





OK - perhaps this is not an issue unless we require to clone a 'JCHEM table'.





Thanks,


Daniel.

actually the way round this (if you table must be JCHEM) is probably





CREATE JCHEM table with relevant standardization.xml using jcman


DROP underlying oracle table


Oracle import your table dmp file


adjust relevant sequence





db.