convert long to clob?

Is there a straightforward way to convert a table with a long column to use a clob column?

tableA=

id	int
txt	long

tableB=
id	int
txt	clob

This statement does not work-
insert into tableB select * from tableA

_hal Received on Fri Mar 19 1999 - 21:58:35 CST