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
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
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
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
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(’18.104.22.168′ + *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
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