Re: newbie's question on control file and SQL Loader

"PC" <prabhaweb_at_netscape.net> wrote in message news:3A740619.FDA3A22_at_netscape.net...
> Hi:
>
> I am trying to load a huge Excel file (.csv) into Oracle. This is my
> first time with control files etc. When I do the control file command at
>
> Unix, ie,
>
> $sqlload control=file1.ctl log=file1.log
>
> I get the following error:
>
> "Name specified is not recognized as an internal/external command,
> operable program or batch file."
>
> What does this mean?
>
> Also, do I code "load data, infile *......." as a script in an SQL
> editor and then run it in SQL Plus?
>
> Thanks,
> PC

It means it can't find the sqlload executable. The program is usually called
sqlldr
on Unix
Alternatively your PATH variable is incorrect.

As to your second question: sqlloader is a separate utility so you can't run it from sql*plus other than by using the host command. As this creates a second O/S session (and a second Oracle session) this is undesirable.

Hth,
Sybrand Bakker, Oracle DBA

>
Received on Sun Jan 28 2001 - 22:24:03 CET