{外部表}終了デリミタを使用した外部表を作成

https://docs.oracle.com/cd/F19136_01/sutil/oracle_loader-access-driver.html#GUID-6B0AED9C-E34E-44EB-8BCF-026708A537AC

vi infoa.dat
Alvin Tolliver 1976 
Kenneth Baer 1963 
Mary Dube 1973 

drop table test.ext_a;
CREATE TABLE test.ext_a (first_name CHAR(15), last_name CHAR(20), year_of_birth CHAR(4))
  ORGANIZATION EXTERNAL (TYPE ORACLE_LOADER DEFAULT DIRECTORY ORA_DIR
                         ACCESS PARAMETERS (FIELDS TERMINATED BY WHITESPACE)
                         LOCATION ('infoa.dat'));

select * from test.ext_a;