I need to change a CLOB field into a VARCHAR2. I thought of creating a temporary table and inserting the clob and primary key into it. Then deleting the data in the original clob column and modifying it to a varchar2. Then I should be free to insert the data from the temporary table back into the original table. Am I correct in assuming this will work? Is there a better way?