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:
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.