SQL & PL/SQL

Hi all,

we are using sqlloader with the truncate option. The database account used by sqlloader is not the owner of the table that is to be truncated and filled with data, but the account has insert and delete privileges on the table.

The strange thing is, that the documentation states the following.

You must have DELETE privileges on the table to be loaded, when using the REPLACE or TRUNCATE option to empty old data from the table before loading the new data in its place.


It does however seem that sqlloader issues a truncate-statement to truncate the table and thus the privileges are not sufficient and the load fails. Anybody knows if the documentation is wrong or am I missing something?

Thanks!

Timo Elverkemper