wood burning stoves 2.0*
The moose likes JDBC and the fly likes SQLLoader for Data Migration Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQLLoader for Data Migration" Watch "SQLLoader for Data Migration" New topic
Author

SQLLoader for Data Migration

Sri Rangan
Ranch Hand

Joined: Dec 08, 2001
Posts: 160
Hi All,
We are building our J2EE based sofware with Oracle Database. Customers who will buy this new software, have to migrate huge data (more that a few million records) from their existing tables to Oracle database.
Unfortunately, old data are in unstructured and not normailized tables and the data structure will be totally different from our current Oracle Schema.
1) Could SQLLoader be used here?
2) How fast the data transer would happen? The requirement is to migrate the data as quickly as possible.
3)Is SQLLoader Oracle Specific?
4) How complicated to migrate the data using SQLLOADER?
Thanks in Advance
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQLLoader for Data Migration