Newbie: How to migrate data from one DB to another?

I have 2 DB(Oracle 9.0.1 and Oracle 9.2). I need to copy data from first(O9.0.1) to second. The problem is, that i have some tables with columns of datatyp CLOB, and in the new database structure is changed. Like:

Tab1(Old)                 Tab1(new)
col1 varchar(30)          col1 varchar(50)
clo2 number(10)           col2 number(10)
col3 CLOB                 col3 CLOB
                          col4 varchar(50)

Please help with ideas or any sugestions how to do it.

Thanx. Received on Mon Apr 28 2003 - 15:55:34 CEST