Table regeneration

User 93ffa33d02

07-08-2013 11:48:06

We have installed the latest Chemaxon version and table structure must be upgraded. JChem manager wants to upgrade all tables (we have 2), but we need to upgrade only one table (duplicate).


Documentation states:


u --ptid                   upgrades database structure (with recalculation) and
generate a new unique identifier for the currently
used property table. This is needed by the cache if
you use multiple databases or schemas with different
property tables handling the same JChem table names.

Where to get --ptid value for one specific table?

ChemAxon abe887c64e

08-08-2013 14:03:16

Hi,


Unfortunately, only the whole database - all of its tables - can be upgraded, you can not specify tables for upgrade.


ptid - propertytable.identifier - is the identifier of the JChemProperties table,  that is of the whole database.


Best regards,


Krisztina