alter VARCHAR column to TEXT under Oracle

2015-11-08 Thread Ofir Herzas
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

Re: alter VARCHAR column to TEXT under Oracle

2015-11-08 Thread Mike Bayer
On 11/08/2015 05:42 AM, Ofir Herzas wrote: > 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'] > > | > >

RE: alter VARCHAR column to TEXT under Oracle

2015-11-08 Thread Ofir Herzas
Message- From: sqlalchemy-alembic@googlegroups.com [mailto:sqlalchemy-alembic@googlegroups.com] On Behalf Of Mike Bayer Sent: Sunday, November 8, 2015 20:25 To: sqlalchemy-alembic@googlegroups.com Subject: Re: alter VARCHAR column to TEXT under Oracle On 11/08/2015 05:42 AM, Ofir Herzas wrote