Hi,

Oracle 9.2.0.8 Enterprise (Linux)
MySQL (Windows)

Could anyone provide me with a solution(s) to export/migrate schemas
from Oracle to MySql?

Thanks in advance,

tb3101

On Feb 10, 7:16*am, trub3101 <trub3... (AT) sky (DOT) com> wrote:
What have you tried so far?

On Feb 10, 12:59*pm, John Hurley <hurleyjo... (AT) yahoo (DOT) com> wrote:
I have converted a table to tab delimited files and used the MySql
LOAD DATA INFILE command.

On Feb 10, 8:54*am, trub3101 <trub3... (AT) sky (DOT) com> wrote:
We actually just did this, and migrated about 1TB single table to a
reporting database. It took three days, but we hand coded the
migration. We pulled it from Oracle into java, and from there pushed
it into MySQL. We chose this because we had unicode data, and we knew
java would handle it without losing any bits.

On Tue, 22 Feb 2011 16:46:14 -0800, Steve Howard wrote:

That's why it took 3 days: you didn't use Perl. Had you used Perl, it
would have been done in two days.



--
http://mgogala.byethost5.com

Mladen Gogala wrote:
Losing one bit in three?

On Feb 23, 3:18*pm, Mladen Gogala <n... (AT) email (DOT) here.invalid> wrote:
Does Perl handle unicode "easily"? I'm genuinely curious.

It is the one and only thing about python that I dislike intensely.
It's handling of unicode is death. Other than that, I wouldn't have
used java.