I have a problem of converting LONG data type to varchar2 in a table. So I need to create a new table by using the max varchar2(4000) instead of the long defined in the current tables.

The round-about solution is to have a cursor for the table and then insert into a new table with varchar2(4000) data.

But is there any other standard / easy way available?

Table details :
CURRENT:

STATUS CHAR(1),
SEQ_NO NUMBER(10),
DATA LONG

I need to convert this "DATA" field into VARCHAR2(4000).

Thx for the early reply.

Cheers,
Avinash