Java – Disabling contextual LOB creation as createClob() method threw error

This might sound drastic, but when faced with this problem we ended up converting all DATE columns to TIMESTAMP types in the database. There's no drawback to this that I can see, and if Hibernate is your primary application platform then you'll save yourself future aggravation.

Notes:

• The column types may be changed with a simple "ALTER tableName MODIFY columnName TIMESTAMP(precisionVal)".

• I was surprised to find that indexes on these columns did NOT have to be
  rebuilt.

Again, this only makes sense if you're committed to Hibernate.

Generally speaking, Oracle export is not backward compatible with prior releases. You'll need to use the 10g export on the 10g database. Get the 10g client and install it with the database utilities option to get the exp/imp tools. On the flip side, Oracle imp is generally backward compatible with prior releases of exp.