title: Oracle12c: External tables unable to open file
body: <p>I've checked questions about same problems but advices seen theme didn't help me.</p>
  
  <ol>
  <li><p>I've created external table using user <strong>tpch1</strong>.</p>
  
  <pre><code>CREATE TABLE region_ext (r_regionkey  NUMBER,
  r_name VARCHAR2(25),
  r_comment VARCHAR2(152))
  ORGANIZATION EXTERNAL (
  TYPE oracle_loader
  DEFAULT DIRECTORY tpch1_dir
  ACCESS PARAMETERS (
  RECORDS DELIMITED BY NEWLINE
  PREPROCESSOR zcat_dir:'zcat'
  NOBADFILE NODISCARDFILE NOLOGFILE
  FIELDS TERMINATED BY '|'
  MISSING FIELD VALUES ARE NULL
  )     
  LOCATION ('region.tbl.gz'));
  </code></pre></li>
  <li><p>User tpch1 created directories: zcat and tpch1_dir and has read and write permissions to them.</p></li>
  <li><p>Trying to select on this table I get</p>
  
  <pre><code>select count(*) region_count from region_ext
  *
  ERROR at line 1:
  ORA-29913: error in executing ODCIEXTTABLEFETCH callout
  ORA-29400: data cartridge error
  KUP-04001: error opening file E:\mgr\datadir\region.tbl.gz
  </code></pre></li>
  <li><p>I'm working on Windows 7, Oracle 12c. It's for use during the studies so I can change everything.</p></li>
  <li><p>I've also changed properties of these directories. Now Everybody can use it fully and the owner is also Everybody.</p></li>
  </ol>
  
  <p>Plese help me finding the solution :)</p>