On Wed, Nov 17, 2010 at 2:26 PM, who.cat <win....@gmail.com> wrote: > Maybe you can dump as a csv format,then create table all tables in oracle > .After that you can write a script program format the csv to oracle which > can be recognized. >
MySQL's select into outfile may well be good enough to manage to output oracle-formatted inserts; and as I said standard (non-extended) insert syntax is probably good enough for oracle anyway. If you're going to be programming anyway, why not just write something that connects to both DBs and inserts into Oracle using prepared statements for speed ? -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
