SQL> create table t (x long);

Table created.

SQL> insert into t values('asdarewhdfhsdkjfh');

1 row created.

SQL> commit;

Commit complete.

SQL> create table a (x clob);

Table created.

SQL> insert into a select to_lob(x) from t;

1 row created.

SQL> commit;

Commit complete.