How to convert LONG into LOB ????

Hi!

I got two tables that have LONG and LONG RAW datatypes in them.

1. since we are running 8i, it would make sense to convert them to LOB columns, eh? Since we store pictures in those columns, BLOB would be ok, eh?
2. how do I move existing data from the original table to the new table (with LOB column)?

This is 8.1.6 on Win2k.

Thanks,
Helmut

SQLWKS> desc TABLE1;

Column Name                    Null?    Type


------------------------------ -------- ----

EVENTICONID                    NOT NULL NUMBER(38)
DESCRIPTION                             VARCHAR2(50)
USERID                                  NUMBER(38)
ICON                                    LONG RAW
DOCUMENTID                              NUMBER(38)
STATUS                                  CHAR(2)

SQLWKS> desc TABLE2;

Column Name                    Null?    Type


------------------------------ -------- ----

SQLID                          NOT NULL NUMBER(38)
SQLSCRIPT                               LONG
DOCUMENTID                              NUMBER(38)
DESCRIPTION                             VARCHAR2(50)
STATUS                                  CHAR(2)