Re: SQLLDR Question

From: Anil Kamath <akk_16_at_yahoo.com>
Date: Thu, 23 Sep 1999 19:13:16 GMT
Message-ID: <7sdu3u$kpa$1@nnrp1.deja.com>

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

In article <7sdrdg$inj$1_at_nnrp1.deja.com>, amerar_at_ci.chi.il.us 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
> amerar_at_ci.chi.il.us
>
> 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. Received on Thu Sep 23 1999 - 14:13:16 CDT