Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

My sql --- Oracle transformation

  Asked By: Fahimah    Date: Nov 29    Category: Java    Views: 557

I have a problem , I want to transfer some very big
tables from mysql to oracle .
I created some text files via export utility in mysql
(text files contain only sql statements like insert)
and after that I ran them in oracle but before running
in oracle I have to publish them for some syntax
correction and it takes so long.Is there any method to
transfer data directly?



5 Answers Found

Answer #1    Answered By: Iris Sanders     Answered On: Nov 29

yes make to JDBC or other type of connection first one
to oracle  second to mySQL and the rest is obvious.
it is so fast with good drivers (ODBC drivers are a
little slow)

Answer #2    Answered By: Olga Allen     Answered On: Nov 29

I’ve used DBUnit’s import/export Ant tasks for this purpose. See http://dbunit.sf.net/. The export  task exports the data  to xml, the import fills the db from the xml. Works fine, but beware it has some bugs!

Answer #3    Answered By: Botan Suzuki     Answered On: Nov 29

I have tried but my tables are so larg and it did not
work well.I have tested many ways but for these huge
table they did not work.

Answer #4    Answered By: Fahmida Ahmed     Answered On: Nov 29

in what way you fail?
1- is it two slow?
2- data  fields are not compatible?
3- or only parts of the table are copied?

in 3rd case you may have forgotten to ask for rest of
result set in big returned list.
in 1'st case you must wait more.
in 2'nd case you have to recheck the compatibility
list in JDBC drivers.

Answer #5    Answered By: Vidhya Iyer     Answered On: Nov 29

I used oracle sql  loader but my problem  is about that
only part of records were copied and the problem was
realy funny it alarmed about length of one field but
it was enough large(CLOB) after that I changed all of
data type to varchar and it was ok.
thank you so much for your attention.
keep in tuch and let me know about yourself and your

Didn't find what you were looking for? Find more on My sql --- Oracle transformation Or get search suggestion and latest updates.