Current location - Loan Platform Complete Network - Big data management - How to import data from oracle library into db2?
How to import data from oracle library into db2?
1. go text, that is, the oracle imported into a text file, and then it is with load and then imported into db2, now the problem is that I do not know how to import the large amount of data into a text file, with spool is too slow, that big brother there is no good way to pour the text of the a, toad on the amount of large data can not be, but toad exported the text format is very easy to customize. 2. use the warehouse Center, go odbc direct connection, but now I have not been successful, more than ten million, as if this is also very slow. 3, with ibm components, relaciotn connect, but because db2 and oracle hosts want to correspond to the client's oralce code page, so take over the Chinese language can not be displayed, are? It's all ? This is my accumulation of problems and experience in the guide data!