Re: Newbie - SQL *Loader query.

The best way is to look at different examples in c:\orawin95\rdbms73\loader directory (I imagine you have Personal Oracle 7 in your PC). There are many examples in this directory and one of them might be quite similar to what you are trying to do.

In nutshell, you need to make a control file (.ctl file), and need data file. You can load data and create log files to see how the data was loaded.

SC.

barry_deevey_at_my-deja.com wrote:

> Hi,
>
> I'm relatively new to Oracle and apologise if this is the wrong forum
> for my posting. I'm trying to load approx. 200,000 rows of data from a
> flat file into an Oracle table. I'm trying to use SQL *Loader to
> achieve this. Unfortunately the book that I'm using as a reference
> (Oracle DBA Handbook 7.3 Edition by Kevin Loney) states that you can do
> it, but doesn't go as far as to tell you how.
> If anybody knows of any information source that would be of use to me,
> or any pointers as to what I should be trying (or avoiding) they would
> be greatly appreciated.
>
> Many Thanks,
>
> Barry.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Dec 13 1999 - 12:28:39 CST