1
  • External Table / SQL Loader

    Hi, We are using this new SQL loader for a month now and 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...

    External10 pointsBadges:
  • 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.

    ORACLEPLSQLDEVELOPER10 pointsBadges:
  • SQL loader

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

    Mraman260 pointsBadges:
  • MAXTRANS Recommended value

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

    GmJackie5 pointsBadges:
  • 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.

    Rzierler5 pointsBadges:
  • Oracle SQL*Loader (sqlldr) performance tuning

    Good day, I try to optimize sqlldr, but don't know how to set the parameters. I am trying to load 21,000,000 records per day, but currently don't manage to load all data in time. The loading is always 1 day behind. I am using conventional loading (I cannot disable indexes before and after loading,...

    Ws8oBPSQ15 pointsBadges:
  • Commit during loader replace ?

    Hi. I would like to know if sql*loader commits after it deletes the rows when executing loader option replace. Is it possible to make it commit only after everything is done, so that there is no second when the table is empty. Thanks for your help.

    Cgfchat5 pointsBadges:
  • different ways to load data files in oracle database tables

    other than SQL Loader

    Sman5 pointsBadges:
  • Binary Double / Binary Float and SQL*Loader

    Does SQL*loader support database columns Of Binary Double/Float when applying Direct Path?

    Hillel20085 pointsBadges:
  • 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

    Rolandsk5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following