CREATE TABLE EMP_DATA(
    FIRST_NAME VARCHAR2(25),
    LAST_NAME VARCHAR2(25),
    EMAIL VARCHAR2(30))
ORGANISATION EXTERNAL
    (TYPE ORACLE_DATAPUMP
    DEFAULT DIRECTORY STUD
    ACCESS PARAMETERS
    (
    RECORDS DELIMITED BY NEWLINE
    NOBADFILE
    NOLOGFILE
    FIELDS TERMINATED BY '|'
    (FIRST_NAME POSITION (1:20) CHAR,
    LAST_NAME POSITION (22:41) CHAR,
    EMAIL POSITION (43:72) CHAR) )
    )
    LOCATION ('emp.dat')
    PARALLEL 5
    REJECT LIMIT 0;