title: Oracle 11g External Table error
body: <p>I'm trying to run a simple external table program using oracle 11g on Linux VM. The problem is that I can't query any data from .txt files. <br> 
  Here's my code:</p>
  
  <pre><code>    CONN / as sysdba;
  
      CREATE OR REPLACE DIRECTORY DIR1 AS 'home/oracle/TEMP/X/';
      GRANT READ, WRITE ON DIRECTORY DIR1 TO user;
  
      CONN user/password;
  
      CREATE TABLE gerada
      (
          field1   INT,
          field2   Varchar2(20)
      )
      ORGANIZATION EXTERNAL
      (
              TYPE ORACLE_LOADER
              DEFAULT DIRECTORY DIR1
              ACCESS PARAMETERS 
              (
                      RECORDS DELIMITED BY NEWLINE
                      FIELDS TERMINATED BY ';'
                      MISSING FIELD VALUES ARE NULL
              )
              LOCATION ('registros.txt')
      )
      REJECT LIMIT UNLIMITED;
  
      --Error starts here.
      SELECT * FROM gerada;
  
      DROP TABLE gerada;
  
      DROP DIRECTORY DIR1;
  </code></pre>
  
  <p>Here's the error message:</p>
  
  <blockquote>
    <p>ERROR at line 1:<br>
            ORA-29913: error in executing ODCIEXTTABLEOPEN callout<br>
            ORA-29400: data cartridge error<br>
            error opening file home/oracle/TEMP/X/GERADA_3375.log</p>
  </blockquote>
  
  <p>And thats how registros.txt looks like:</p>
  
  <pre><code>    1234;hello world;
  </code></pre>
  
  <p>I've checked my permissions on DIR1 and I do have read/write permissions.</p>
  
  <p>Any ideas?</p>