Working example, execute as sys:
create or replace directory import_dir as '/home/oracle/consulta_import'; grant read on directory import_dir to some_user; grant write on directory import_dir to some_user; Execute as some_user: CREATE TABLE ADDR_MNLA_CONSULTA_EXT ( municipio varchar2(100) , cod_ibge varchar2(10) , uf varchar2(2) , nome_rua varchar2(100) , cep varchar2(10) ) ORGANIZATION EXTERNAL ( TYPE oracle_loader DEFAULT DIRECTORY import_dir ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE SKIP 1 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' MISSING FIELD VALUES ARE NULL (municipio, cod_ibge, uf, nome_rua, cep) ) LOCATION ('consulta_utf8.csv') ) ;