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