Re: SQL LOADER

ulysse51_at_my-deja.com writes:

> i want to load some data in a table with sql loader in direct path, my
> control file seems like :
>

[...]
> 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
[...]

If you don't absolutely need to use IMPORT_SEQ, try using SEQUENCE instead:

(
LINE_ID SEQUENCE,
...

With SEQUENCE, you can also specify the starting value and increment. See the SQL*Loader guide for more information.

--
Andy Robinson Received on Fri Mar 10 2000 - 09:04:12 CST