Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*Loader Question
Hi David,
You can create a batch file that invoke a SQL*Loader, like in the follow example:
Batch file: charge.bat
SQL*Loader username/password_at_service_name control=controlfile.ctl log=logfile.log bad=bafile.bad
Jorge Alves.
-----Original Message-----
From: Lieuallen, David [mailto:David.Lieuallen_at_UNCO.EDU]
Sent: Monday, August 07, 2000 3:05 PM
To: Multiple recipients of list ORACLE-L
Subject: SQL*Loader Question
Is there a way to execute SQL*Loader in batch mode? I would like to script the loading of several tables using SQL*Loader but I cannot find any documentation on the subject. I'm on Oracle 8.1.5 and Windows NT. I can invoke a sqlldr command from the windows command prompt successfully but batch mode would be much better. Thanks in advance.
David Lieuallen
-- Author: Lieuallen, David INET: David.Lieuallen_at_UNCO.EDU Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Mon Aug 07 2000 - 16:59:16 CDT