Re: mysqlsdump to Oracle 8i?

From: <hclarius_at_mindspring.com>
Date: Tue, 21 Mar 2000 16:44:22 -0800
Message-ID: <38D81766.6A9F13F5@mindspring.com>

I created a comma-delimited file using double quotes from a mysql table. I then used sqlldr using FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ' " '. Since I was not acquainted with mysql, the default null values '/N' gave me some pain. If you know mysql set your NULL to something else and or use NULLIF to set your NULL values in the Oracle load. Let me know if you have more specific questions.

jawa803_at_yahoo.com wrote:

> Could someone tell me how to import a mysqldump into Oracle 8i? If
> someone could point me in the right direction, I'd appreciate it.
>
> Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Mar 21 2000 - 18:44:22 CST