Re: Load REPLACE need specific object privilege

When you use the REPLACE option SQL*Loader tries to truncate the table you're loading data into. If the table is not in your schema then I think you need DROP ANY TABLE or DELETE ANY TABLE privilege to truncate it.

kcheung_at_poboxes.com wrote:

> Dear all,
>
> I have INSERT, UPDATE and DELETE privilege on a certain view but I
> cannot load data into the view if the control file is using LOAD REPLACE
> option. What else privilege do I need ?
>
> Kevin
Received on Sun Aug 09 1998 - 23:24:27 CDT