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

Join the conversationComment
Share
Comments
Results
Contribute to the conversation