SQL copy column AND change data type
===

I have a table which is already populated.

I need to change the data type of one column from LONG to CLOB

However this database is hosted by a third party and the tablespace is limited.

I know the command:

    ALTER TABLE myTable MODIFY my_data CLOB

However I then receive the error after a long wait:

    ORA-01652: unable to extend temp segment by 128 in tablespace

Increasing the table space is not an option.

Is there any work arounds?

Could I create a new column with the data type CLOB then copy and convert the data from my_data ( LONG) without draing table space? Could i turn undo off to help?


Many thanks