Re: priviledge for sqlldr direct mode
From: Ron Reidy <rereidy_at_indra.com>
Date: Tue, 13 Nov 2001 09:58:50 -0700
Message-ID: <3BF1514A.39ED5449_at_indra.com>
Date: Tue, 13 Nov 2001 09:58:50 -0700
Message-ID: <3BF1514A.39ED5449_at_indra.com>
Gloria Zhao wrote:
>
> Hi there,
>
> When I used sqlldr with direct mode, I got the following error:
>
> Error calling once/load initialization
> ORA-28116: insufficient privileges to do direct path access
>
> Could someone tell me if there is a special priviledge needed for it
> besides insert priviledge?
>
> Thanks,
>
> Gloria
Was $ORACLE_HOME/rdbms/admin/catldr.sql executed when the instance was
created (i.e do the views LOADER_TAB_INFO, etc. exist) and does the
connect sqlldr user have access to these views?
-- Ron Reidy Oracle DBA Reidy Consulting, L.L.C.Received on Tue Nov 13 2001 - 17:58:50 CET