trouble creating a new IJC schema in Oracle

User 4bdb1b72f8

20-07-2010 20:51:49

I am having trouble creating a new IJC schema in Oracle.

Previously, I had created an IJC schema within the same Oracle schema, but this first IJC schema was deleted using the Instant JChem interface.  Now when I attempt to create a second IJC schema, I get the following error message:

Caused: StatementCallback; bad SQL grammar [select PROP_NAME, PROP_VALUE, PROP_VALUE_EXT from <ORACLESCHEMANAME>.BIN$i8L7jDD+tN3gQK1FDEEpAQ==$0]; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended



ChemAxon fa971619eb

21-07-2010 09:34:09

This is related to the present of Oracle's flashback tables (these allow deleted tables to be undeleted, and appear in some version of Oracle as tables with strange names starting with BIN$).

IJC should be hiding these, but it seems this is not working correctly, and we are fixing this.

To avoid the problem you can purge the flashback tables using you DB management tool (e.g. SQLPlus) with something like this:


Please let us know if this helps solve the problem.



User 4bdb1b72f8

21-07-2010 16:26:35

Thanks Tim.

That solved the problem.

ChemAxon fa971619eb

21-07-2010 16:39:35

We have hopefully also fixed the problem in today's IJC 5.3.6 release, so with luck it should not reappear.