Re: sql loader

Assuming you need to overwrite the data already in the table with the data provided to you in the .txt file, you need either to truncate your table manually using sqlplus or place the replace keyword immediately after the load data line in your control file. Of course replace is only one of the alternatives, append is also possible, insert being the default. Insert will only work when there are no rows in the table. Otherwise you will get the error you just got.
I can not know whether you need to append or replace data, so I can't provide you with the final answer.

Hth,

Sybrand Bakker, Oracle DBA
. wrote in message <7eav8h$hgg$1_at_platane.wanadoo.fr>...
>I'm trying to import data in a tablespace where data already exist. I got
my
>data to import in a .txt file with his description in a .ctl file.
>when I use sqlloader, I get this message: for insert option, table must be
>empty.
>what can I do ?
>
>thanks for helping me
>
>thomas
>
>
>
>
Received on Mon Apr 05 1999 - 14:03:17 CDT