I want to mirate all the data from mysql to oracle8i. Any program can do that? I got a column which contains >5000 character. Should I use "long" in oracle? coz varchar(4000) doesn't work. Thanks!
Actually you should use clob which really is a long so to speak. clob=character long/large object. Something like that. You could always export mysql data to a text file, then use SQL*Loader to load into Oracle Mark
