2 Replies Latest reply on Jan 30, 2014 9:28 AM by DK2010

    Trying to load documents using sqlldr and getting sql*loader-502,553 and 509 errors

    hh*394375*91

      I am trying to load 8700 documents.  64 for are loaded with the following error message before it stops.

       

      SQL*Loader-502: unable to open data file 'F68CD83A25C4E44788256D350066BA95_DSR_DSRDescription_1.pdf' for field BLOB_CONTENT table FILE_TEMP_BLOB_ST1

      SQL*Loader-553: file not found

      SQL*Loader-509: System error: The system cannot find the file specified.

       

      I am not sure what I am doing wrong.

       

      I used the following to run it:

      sqlldr userid=e406702/e406702@APEXD4 control=c:\Attachments\Att

      achment_Index.ctl log=c:\Attachments\Attachment_index.log bad=c:\Attachments\Att

      achment_index.bad

       

      I have change directories to the Attachment folder and ran from there.

      I have also use this statement

      sqlldr userid=e406702/e406702@APEXD4 control=c:\Attachments\Att

      achment_Index.ctl log=c:\Attachments\Attachment_index.log direct=true

       

      Attachment_Index.ctl 

      LOAD DATA

       

      INFILE 'c:\Attachments\Attachment_Index.txt'

       

      INTO TABLE FILE_TEMP_BLOB_ST1

       

      APPEND

       

      FIELDS TERMINATED BY '<:s:>'

       

      (blob_filename CHAR(500),

       

      blob_actual_filename CHAR(500),

       

      blob_content LOBFILE(blob_filename) TERMINATED BY EOF)

       

      Attachment_Index.txt

      8132F0C4EC6384BC88256D340061E0F1_DSR_DSRDescription_1.pdf<:s:>Request from Javier.pdf

      2C8543BE5322F0CF88256D340067150F_DSR_DSRDescription_1.pdf<:s:>Request from Siliva V.pdf

      3E59F2D3E4262FAE88256D3400679FF3_DSR_DSRDescription_1.pdf<:s:>DSR-112 (1).pdf

      3E59F2D3E4262FAE88256D3400679FF3_DSR_DSRDescription_2.pdf<:s:>DSR-112 (2).pdf

       

      Folder called Attachments with the documents.

       

      Also, I am working with items that have the extensions pdfs,frt,prg.  Does this have any affect?

      I appreciate any help.

       

      Howard

      Thanks