I am confused What do you mean by metadata? tables definition? or data itself.
if tables definition, then you need to use mysql syntax to create tables/contraints .. etc.
if you mean actual data tah tcould be imported, then it is not called meta-data
I just recommended some tool fastreader for fast Oracle data migration to mysql:
http://forums.mysql.com/read.php?61,129757,134147#msg-134147
We use it for a while. Fastreader allows to configure any multi-character values for column separator or row terminator, etc. even non-printable characters supported. Pretty handy when data is free text and can contain delimiter value which causing import to fail.
Hope it helps
max dix Wrote:
-------------------------------------------------------
> Hi, i have a simply strong question:
> i want to export metadata from oracle to text file
> and use import command to load data to mysql.
> the migration toolkit doen't work in my case.
> the problem is that i need to decide fields
> teminated and and row terminaterd not as simple
> one caracter but more, exemple
> fields terminaterd @@@@
> row terminated ####
>
> when i used sybase there is a funcioon that is
> called bcp that u can export metadata in text
> file, but in oracle 9i, i don't know how i can
> do.
>
> thank s a lot