Humberto,

Try going into the LazyDBA site and searching for SQL*Loader and looking
at some of the other examples there. There are some that contain links to
show the actual *ctl files, data files, etc. I think you might find it
very helpful. Also, you might want to try going to http://www.oreilly.com/catalog/orsqlloader/chapter/ch01.html. This is the O'Reilly Book on Oracle SQL*Loader and contains the first
chapter which should answer most of your questions. It is quite helpful.

Rhonda






"Humberto Alexandre V. Lima "
<oracledba-ezmlmshield-x38051860.[Email address protected]
10/27/2005 02:04 PM


To: "LazyDBA Discussion" <[Email address protected]
cc: (bcc: Rhonda Treadway/CV/Novartis)
Subject: FW: SQL*Load


Gurus,
I changes my aproach, i have created a id for each line in a text file and
still trying to load with SQL*Load
But now the load gives me the error:
Record 116: Rejected - Error on table SUPP_SERASA, column COL1.
Field in data file exceeds maximum length
And it aborts the load!

My string is 700 chars long and the COL1 column is Varchar2(4000).

How can it be possible? Isn't it enough space in 4000 bytes for a string
700
bytes long???

Does anyone have any idea about what is going on?


Tks and have a nice day
Humberto

-----Original Message-----
From: Cliff Palmer
[mailto:oracledba-ezmlmshield-x62922111.[Email address protected]
Sent: quinta-feira, 27 de outubro de 2005 14:25
To: LazyDBA Discussion
Subject: Re: SQL*Load

Humberto, you need to look further into the SQL*Loader documentation.
In particular you need to find how to describe the contents of the text
file to SQL*Loader so it knows how to find the values for the columns in
supp_help.
Once you have done that you can look into adding a sequential value.
HTH
Cliff
On Thu, 2005-10-27 at 13:02 -0200, Humberto Alexandre V. Lima wrote:
> Hi gurus,
>
>
>
> I'm trying to load data into oracle with Sql*loader, everything went
fine
> but I need a PK to regulate the order of the lines loaded, and I don't
know
> how to add a PK during a simple load, like this:
>
> /* This is my config.cfg */
>
> load data
>
> infile 'Acesso.txt'
>
> into table supp_help( col1 char(1500) )
>
> /* End of config.cfg */
>
>
>
> inside that table:
>
> CREATE TABLE supp_help(
> num int not null,
> col1 CHAR(1500) NULL,
> constraint supp_help_pk primary key(num)) tablespace teste_data
>
>
> It complains about the insert of null values inside the num field.
>
> Don't know how to add the PK field during the load.
>
>
>
> Can someone give me a clue about how to solve that?
>
> If you send me a good link to read about SQL*loader is enough.
>
>
>
> Tks in advice.
>
>
>
> Humberto



Oracle LazyDBA home page