The problem is not your sequence , but that you can not load a delimited
file in a direct path mode You MUST use a conventional mode to load this
data
<ulysse51_at_my-deja.com> wrote in message news:8aajr8$65r$1_at_nnrp1.deja.com...
> hi there,
>
> i want to load some data in a table with sql loader in direct path, my
> control file seems like :
>
> Options (DIRECT = True)
> UNRECOVERABLE
> Load Data
> APPEND
> INTO TABLE INPUT
> FIELDS TERMINATED BY ";" OPTIONALLY ENCLOSED BY '"'
> (
> LINE_ID "IMPORT_SEQ.NEXTVAL", SOURCE_FILE
> CONSTANT "C:\\Windows\\temp\\\File000.csv", USERID CONSTANT "JPB1",
> ID_INTERNAL_SOURCE,EXTERNAL_SOURCE,.......)
>
> without the options (direct=true) it works but with this option i've
> got the message : not allowed in direct path on column line_id, i
> precise that in this column i want to put a sequence
> thanks for your help
> best regards
> Fred
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Mar 10 2000 - 16:52:21 CST
