title: SQLLDR control file: Loading multiple files
body: <p>Iam trying to load several data files into a single table. Now the files themselves have the following format:</p>
  
  <pre><code>                          file_uniqueidentifier.dat_date
  </code></pre>
  
  <p>My control file looks like this</p>
  
  <pre><code>    LOAD DATA
       INFILE '/home/user/file*.dat_*'
         into TABLE NEWFILES
           FIELDS TERMINATED BY ','
            TRAILING NULLCOLS
                  (
                       FIRSTNAME  CHAR NULLIF (FIRSTNAME=BLANKS)
                      ,LASTNAME   CHAR NULLIF (LASTNAME=BLANKS)
                               )
  </code></pre>
  
  <p>My SQLLDR on the other hand looks like this </p>
  
  <pre><code>                sqlldr control=loader.ctl, userid=user/pass@oracle, errors=99999,direct=true
  </code></pre>
  
  <p>The error produced is SQL*Loader-500 unable to open file (/home/user/file*.dat_*)  SQL*Loader-553 file not found</p>
  
  <p>Does anyone have an idea as to how I can deal with this issue?</p>