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.
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 [...]
Like to hear best practices to be followed to increase performance of SQL loader.
SQL*LOADER-926 ERROR recommends increasing MAXTRANS (Now 255) to a larger value… like what?
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.
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





