Re: importing the text files

On Sat, 29 Jan 2005 08:49:43 GMT, "rajasekhar via OracleMonster.com" <forum_at_OracleMonster.com> wrote:

>hello sir,
>u gave the option of sqlloader for importing text files.so i have gone thru the manuals of sqlloader and obtained the following code and i typed the following code at sql prompt
>
>load data
>infile 'example.dat' "str '|\n'"
>into table example
>fields terminated by ',' optionally enclosed by '"'
>(col1 char(5),
> col2 char(7))
>
>it is giving an error
>invalid sql statement load
>
>so please give me the response at the earliest possible.
>
>thanking you.

sqlloader is a separate utility.
You need to save the code above as a separate file with the extention .ctl
and fire up sql*loader in a dos box
using
sqlldr username/password_at_database control=<file above> data=<name of your input file> log=<any file>

If you did read the Utilities Manual, I would suggest re-reading it.

--
Sybrand Bakker, Senior Oracle DBA