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
>
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page