monline

I've stumbled upon a bug regarding the CREATE$JAVA$LOB$TABLE and the JAVA$CLASS$MD5$TABLE tables.

These tables are created if you load a JAVA class into the schema or create a JAVA SOURCE object using the CREATE OR REPLACE JAVA SOURCE ... syntax.

The bug occurs if you create these tables manually. The symptom is an "ORA-01460: unimplemented or unreasonable conversion requested" error, it might be triggered by a number of commands/operations.

So if you extract all table DDLs from a schema using some tool, then do not forget to remove the CREATE TABLE statements for these two tables! If you forget and create them manually, then the data dictionary gets corrupted and the dropping of these two tables does not solve the problem. You'll have to recreate the whole schema.

I've found this bug in Oracle 9.2.0.1.0 for Windows (x86). I do not know whether it matters, but the database had AL32UTF8 characterset.