Answer:

For the column which is a sequence provide this
in the control file where u are indicating data sizes

col_name SEQUENCE(MAX,1)

-anil
 

Question:

In article <[email protected]>,
  [email protected] wrote:
>
>
> Hello,
>
> I have an Oracle table that has a composite primary key, and one of
the
> fields is a sequence.
>
> I am going to populate the data in this table using SQLLDR and loading
> the data from a text file.  I get this error message:
>
> SQL*Loader-923: Column SEQNO in table BLDG_ID_LIST is NOT NULL but is
> not being loaded
>
> How am I supposed to populate a sequence using SQLLDR???
>
> Thanks,
>
> Arthur
> [email protected]
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

--
Anil Kamath
SmartOnline Inc. (www.smartonline.com)
 

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.