Ask the Expert

Techniques for faster data loading instead of using Java

I want to know how to load data in a faster, more efficient way using the new 9i features, instead of loading data through Java. Right now, I am using Java methodology, and it's very slow. How do I use an external table to merge data, and do delete, update, and insert?

    Requires Free Membership to View

To load data fast, I would suggest using Oracle 9i's External Tables. Once the external table is defined, you can write your own SQL routines to move the data from the external table to your normal database tables. I have a white paper on my web site titled "Data Loading with External Tables" which discusses this topic. My web site can be found at this URL:

http://www.peasland.net


This was first published in October 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.