• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

SQLLoader for Data Migration

 
Ranch Hand
Posts: 160
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Why is the word "abbreviation" so long? And this ad is so short?
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic