how to import csv file to oracle 9i

Forum Moderators: open

Message Too Old, No Replies

5:06 pm on Oct 26, 2009 (gmt 0)

HI,
Can you please provide me tutorials or samples regarding how to import a csv file into oracle 9i. we're using toad.

4:34 pm on Nov 6, 2009 (gmt 0)

You should search SQL*Loader, that is the tool you will need.

The first couple of search results that came up for me have good overviews on how to code SQL*Loader control and command files.

It seems complicated at first, but after you have done it once it's really pretty simple.

Damon