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:

This was first published in October 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: