SQL> CREATE OR REPLACE DIRECTORY fingerprint_dir AS 'g:\oradir\fingerprint';

Directory created.

SQL> GRANT READ  ON directory fingerprint_dir to public;

Grant succeeded.

SQL> GRANT WRITE ON directory fingerprint_dir to public;

Grant succeeded.

SQL> 
SQL> DROP   TABLE data.ext_fingerprint PURGE;

Table dropped.

SQL> CREATE TABLE data.ext_fingerprint 
  2    (
  3      userid  VARCHAR2(10) , 
  4      name    VARCHAR2(50), 
  5      dt      VARCHAR2(20) , 
  6      wkday   VARCHAR2(10) , 
  7      firstin VARCHAR2(10) , 
  8      lastout VARCHAR2(10)  
  9    ) 
 10   ORGANIZATION EXTERNAL  
 11   (
 12    TYPE              oracle_loader 
 13    DEFAULT DIRECTORY fingerprint_dir 
 14    ACCESS PARAMETERS 
 15       (
 16        RECORDS DELIMITED BY newline 
 17        SKIP 1 
 18        FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
 19         (
 20           userid  CHAR(10) , 
 21           name    CHAR(50), 
 22           dt      CHAR(20) , 
 23           wkday   CHAR(10) , 
 24           firstin CHAR(10) , 
 25           lastout CHAR(10)  
 26         )
 27       )
 28    LOCATION ('report.csv') 
 29   )
 30   REJECT LIMIT 1
 31  ;

Table created.

SQL> 
SQL> select * from data.ext_fingerprint order by 1,3;
select * from data.ext_fingerprint order by 1,3
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
error opening file g:\oradir\fingerprint\EXT_FINGERPRINT_2040_17328.log

ALTER TABLESPACE tablespacename ADD datafile 'F:\DataFiles\DataFile08.dbf' size 100M REUSE AUTOEXTEND ON ; 

SQL> conn data/ioiuuyjkjjkghhg@jstt
Connected.
SQL> CREATE OR REPLACE DIRECTORY fingerprint_dir AS 'c:\oratext'; 

Directory created.

SQL> GRANT READ  ON directory fingerprint_dir to public; 

Grant succeeded.

SQL> GRANT WRITE ON directory fingerprint_dir to public; 

Grant succeeded.

SQL> 
SQL> DROP   TABLE data.ext_fingerprint PURGE;

Table dropped.

SQL> CREATE TABLE data.ext_fingerprint 
  2    (
  3      userid  VARCHAR2(10) , 
  4      name    VARCHAR2(50) , 
  5      dt      VARCHAR2(20) , 
  6      wkday   VARCHAR2(10) , 
  7      firstin VARCHAR2(10) , 
  8      lastout VARCHAR2(10)  
  9    ) 
 10   ORGANIZATION EXTERNAL  
 11   (
 12    TYPE              oracle_loader 
 13    DEFAULT DIRECTORY fingerprint_dir 
 14    ACCESS PARAMETERS 
 15       (
 16        RECORDS DELIMITED BY newline 
 17        SKIP 1 
 18        FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
 19         (
 20           userid  CHAR(10) , 
 21           name    CHAR(50), 
 22           dt      CHAR(20) , 
 23           wkday   CHAR(10) , 
 24           firstin CHAR(10) , 
 25           lastout CHAR(10)  
 26         )
 27       )
 28    LOCATION ('report.csv') 
 29   )
 30   REJECT LIMIT 1
 31  ;

Table created.

SQL> 
SQL> select * from data.ext_fingerprint order by 1,3;
select * from data.ext_fingerprint order by 1,3
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
error opening file c:\oratext\EXT_FINGERPRINT_2040_17812.log

CREATE OR REPLACE DIRECTORY fingerprint_dir AS 'C:\ORATEXT';