trouble creating a new IJC schema in Oracle

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: java.io.IOException: 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

 

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:

PURGE RECYCLEBIN;

Please let us know if this helps solve the problem.

 

Tim

Thanks Tim.

That solved the problem.

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

Tim