SQL Loader
We have a requirement to insert records starting with 06,08 and 15.In other words, records starting with 09,10 and 11 should not be inserted into target table.

Answer Question   |  September 10, 2012  2:47 AM
SQL Loader, SQL Loader records

External Table / SQL Loader
Hi, We are using this new sqlloader for a month nowmand it is working fine, but suddenly when we upload new csv files from the client we received this error message when i select the table it gave me this message: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-29400: data cartridge error KUP-04001: error opening file [...]

Answer Question   |  March 14, 2012  2:50 PM
PL/SQL, SQL Loader, SQL Server

SQL loader
Like to hear best practices to be followed to increase performance of SQL loader.

Answer Question   |  August 25, 2009  6:16 AM
Oracle 11g, Oracle Database, Oracle Database 11g, SQL Loader

MAXTRANS Recommended value
SQL*LOADER-926 ERROR recommends increasing MAXTRANS (Now 255) to a larger value… like what?

Answer Question   |  June 25, 2009  7:27 PM
MAXTRANS, SQL Loader

excuting sql loader from runrmtcmd from as400 to unix
I am tryint to execute a sql loader process on a Unix machine from the AS400. Here is the code, RUNRMTCMD CMD(‘cd /home/dekbf/e3data;$sqlldr ekbf/ekbf + control=EPINTORD2CTL.CTL’) RMTLOCNAME(’191.0.0.9′ + *IP) RMTUSER(‘dekbf’) RMTPWD(‘ekbf’) Here is the error returned, ksh: ekbf/ekbf: not found.

Answer Question   |  April 22, 2009  6:46 PM
AS/400, RUNRMTCMD, SQL Loader, Unix

Using shell execute from Visual Basic
How can I use the function Shell Execute in Visual Basic Code. I am running MsAccess. I want to use the Shell execute command ro run sqlloader command which loads data into an Oracle table. Would benice to have an example of this. /Roland

Answer Question   |  May 1, 2008  5:34 AM
Microsoft Access, Oracle, ShellExecute, SQL Loader, Visual Basic