Now that you have your data in a text file, you can use Oracle's SQL*Loader utility to load the data into an Oracle database. There are many options on how to use SQL*Loader, most of which are unique to specific situations. I highly recommend reading the Oracle Utilities Guide, particularly Chapters 3 through 10, which talk about how to use SQL*Loader. Chapter 10 is really nice because it gives you step-by-step examples on a number of different scenarios.
This was first published in July 2005