Q

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?

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

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close