create directory emp_tab as '/home/oracle';
grant read, write on directory emp_tab to scott;
CREATE TABLE &Table_name
(&Column1_name &datatype_col1,
&Column2_name &datatype_col2,
&Column3_name &datatype_col3)
ORGANIZATION EXTERNAL
(TYPE ORACLE_LOADER
DEFAULT DIRECTORY &Directory_name
ACCESS PARAMETERS
(RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ‘,’
MISSING FIELD VALUES ARE NULL)
LOCATION (’&type_text_file_name’))
REJECT LIMIT UNLIMITED;
