External Tables: Querying Data From Flat Files in Oracle

mkdir -p /data1/stream/ygzhou_dir

1.1、strings inputScripts.sql 
CREAT OR EREPLACE DIRECTORY dir_dump as '/data1/stream/ygzhou_dir';
CREATE TABLE input(
  id  INT,
  name  VARCHAR2(50)
ORGANIZATION EXTERNAL (
  TYPE ORACLE_LOADER
  DEFAULT DIRECTORY dir_dump
  ACCESS PARAMETERS (
    RECORDS DELIMITED BY NEWLINE
    FIELDS TERMINATED BY ','
    MISSING FIELD VALUES ARE NULL
    (
      id     CHAR(5),
      name   CHAR(50)
    )
  LOCATION ('ygzhou.txt')
PARALLEL 5
REJECT LIMIT UNLIMITED;

1.2、strings outputScripts.sql 
create table Output
organization external
( type oracle_datapump
default directory dir_dump
location ('output_part1.dat','output_part2.dat')
PARALLEL 2
select owner,table_name,tablespace_name from all_tables where wner='SYSTEM';