Changing a VARCHAR column to CLOB (TEXT) raises the following exception under Oracle:
sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-22858: invalid alteration of datatype [SQL: 'ALTER TABLE tab MODIFY col CLOB'] While this is an Oracle fault, it would be nice if the abstraction layer took care of it. The proposed solution that I found was to add a new clob column, copy the data, remove the old column and rename -- You received this message because you are subscribed to the Google Groups "sqlalchemy-alembic" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy-alembic+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.