• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Bear Bibeault
  • Liutauras Vilda
  • Devaka Cooray
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • Henry Wong
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • salvin francis
  • Frits Walraven
  • Piet Souris

SQLLoader for Data Migration

 
Ranch Hand
Posts: 160
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
You will always be treated with dignity. Now, strip naked, get on the probulator and hold this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!