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


Oracle LazyDBA home page