Import big text data to oracle External tables

Oracle External table to import big text data 1, first create the file storage path create or replace directory phone_dir as 'e: \ oracledir'; if it is not in the current user to create a directory, GRANT the permission: grant read, write on directory phone_dir TO scott; if the scott user needs to create a DIRECTORY permission: grant create any directory to scott;
2. There are more than lines of text data. One field is a telephone number. Create table phone_dir_data (phonenumber varchar2 (50 )) organization external (type oracle_loader default directory phone_dir access parameters (records delimited by newline nobadfile nodiscardfilenologfile fields terminated by '"'missing field values are null comment') reject limit unlimited author alang85