CLOB to VARCHAR2

Hi,

I need convert the type of a column from a CLOB to a VARCHAR2 without having to re-import millions of rows of data again.

        Existing table:

	CREATE TABLE my_table
	(
		id		NUMBER(8),
		value		CLOB
	);

I need to convert the CLOB to a VARCHAR2, but...

        ALTER TABLE my_table MODIFY (value VARCHAR2(2000));

yields an error. The manual says I should create a new column and copy the data.

        ALTER TABLE my_table ADD (new_value VARCHAR2(2000));

Ok, so how do I copy the CLOB data into the VARCHAR2??

Cheers,

Andy Received on Mon Oct 22 2001 - 07:14:58 CDT