Hello,
It should be possible to connect Oracle to the MySQL (or other) database
using a DBlink (using a MySQL ODBC driver)
the tables could then be copied using PLSQL.
Maybe you could link directly to Oracle and copy the code using MySQL
procedures or scripts (I have more experienc of Oracle
update mydata set column1 = column2, column2 = column1
(works in sqlserver, can't try mysql at the moment)
You can select which rows by adding a where clause obviously.
I suppose that the field values are copied to a buffer which is the written
to the table at the end of the update (or row by
The separate table for the IDs is probably best solution, maybe counting on
caching of the table with an index on the id value to speed up the 'where'
clause; this checks what numbers are left instead of what numbers have been
used; the disadvantage is that you have to manage a second table