Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Tool to load data
David,
You could create a script that executes the sqlldr with a
parameterfile and then only give permissions to the userid that you want
to do the load.
ie: sqlldr parfile=path/file.par
Ron
>>> david.m.nguyen_at_xo.com 10/02/02 01:44PM >>>
Hi all,
I'd like to know if there is some tool we can use to automate loading
data
into database using SQLLDR either via GUI or scripts. I need to allow
someone to login the system to bulk load data without worrying he
destroys
database. Any advices will be appreciated.
Regards,
David
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: RROGERS_at_galottery.org Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Oct 02 2002 - 13:18:25 CDT
![]() |
![]() |