CREATE TABLE EXT_ST_FINANCEIRO_REAL (
DT_DATA   NUMBER,
  TIPO      NUMBER,
  ENTIDADE  NUMBER,
  VALOR     Varchar2(40))

ORGANIZATION EXTERNAL
(TYPE oracle_loader
DEFAULT DIRECTORY FILE_LOC_OWBARQUIVOS
ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE
BADFILE FILE_LOC_OWBARQUIVOS:'EXT_ST_FINANCEIRO_REALIZADO.bad'
LOGFILE FILE_LOC_OWBARQUIVOS:'EXT_ST_FINANCEIRO_REALIZADO.log'
FIELDS TERMINATED BY WHITESPACE
REJECT ROWS WITH ALL NULL FIELDS
MISSING FIELD VALUES ARE NULL
(         DT_DATA  INTEGER TERMINATED BY WHITESPACE NULLIF DT_DATA=BLANKS, 
          TIPO     INTEGER TERMINATED BY WHITESPACE NULLIF TIPO=BLANKS, 
          ENTIDADE INTEGER TERMINATED BY WHITESPACE NULLIF ENTIDADE=BLANKS, 
          VALOR    CHAR(40) TERMINATED BY WHITESPACE NULLIF VALOR=BLANKS))
LOCATION (FILE_LOC_OWBARQUIVOS:'EXT_ST_FINANCEIRO_REALIZADO.txt'))
REJECT LIMIT UNLIMITED
NOPARALLEL
NOMONITORING;

CREATE TABLE EXT_ST_FINANCEIRO_REAL (
DT_DATA   NUMBER,
  TIPO      NUMBER,
  ENTIDADE  NUMBER,
  VALOR     Varchar2(40))
ORGANIZATION EXTERNAL
(TYPE oracle_loader
DEFAULT DIRECTORY FILE_LOC_OWBARQUIVOS
ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE
BADFILE FILE_LOC_OWBARQUIVOS:'EXT_ST_FINANCEIRO_REALIZADO.bad'
LOGFILE FILE_LOC_OWBARQUIVOS:'EXT_ST_FINANCEIRO_REALIZADO.log'
FIELDS TERMINATED BY WHITESPACE
REJECT ROWS WITH ALL NULL FIELDS
MISSING FIELD VALUES ARE NULL
(         DT_DATA  INTEGER TERMINATED BY WHITESPACE NULLIF DT_DATA=BLANKS, 
          TIPO     INTEGER TERMINATED BY WHITESPACE NULLIF TIPO=BLANKS, 
          ENTIDADE INTEGER TERMINATED BY WHITESPACE NULLIF ENTIDADE=BLANKS, 
          VALOR    CHAR(40) TERMINATED BY WHITESPACE NULLIF VALOR=BLANKS))
LOCATION (FILE_LOC_OWBARQUIVOS:'EXT_ST_FINANCEIRO_REALIZADO.txt'))
REJECT LIMIT UNLIMITED
NOPARALLEL
NOMONITORING;

SQL> select * from v$version
  2  /

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Solaris: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> get ri
  1  CREATE TABLE EXT_ST_FINANCEIRO_REAL (
  2  DT_DATA   NUMBER,
  3    TIPO      NUMBER,
  4    ENTIDADE  NUMBER,
  5    VALOR     Varchar2(40))
  6  ORGANIZATION EXTERNAL
  7  (TYPE oracle_loader
  8  DEFAULT DIRECTORY MOD_SOURCE
  9  ACCESS PARAMETERS (
 10  RECORDS DELIMITED BY NEWLINE
 11  BADFILE MOD_SOURCE:'EXT_ST_FINANCEIRO_REALIZADO.bad'
 12  LOGFILE MOD_SOURCE:'EXT_ST_FINANCEIRO_REALIZADO.log'
 13  FIELDS TERMINATED BY WHITESPACE
 14  REJECT ROWS WITH ALL NULL FIELDS
 15  MISSING FIELD VALUES ARE NULL
 16  (         DT_DATA  INTEGER TERMINATED BY WHITESPACE NULLIF DT_DATA=BLANKS,
 17            TIPO     INTEGER TERMINATED BY WHITESPACE NULLIF TIPO=BLANKS,
 18            ENTIDADE INTEGER TERMINATED BY WHITESPACE NULLIF ENTIDADE=BLANKS,
 19            VALOR    CHAR(40) TERMINATED BY WHITESPACE NULLIF VALOR=BLANKS))
 20  LOCATION (MOD_SOURCE:'EXT_ST_FINANCEIRO_REALIZADO.txt'))
 21  REJECT LIMIT UNLIMITED
 22  NOPARALLEL
 23* NOMONITORING
 24  /

Table created.