Insert 2 million data (how the external table is loaded)

1 Data Source 200w
2 Use the data from the external table to load, import data 1) Create a directory with another DBA user and authorize the directory to the current user (if created with this user, then report ORA-29400: Error opening file D:\XX.log with Data plugin error)
2) Create external table

CREATE TABLE "External_table_test"
(
 ID VARCHAR (),
 NAME VARCHAR ()
)
organization EXTERNAL
(
 TYPE oracle_loader
 DEFAULT DIRECTORY extdir_1
 ACCESS PARAMETERS
 (
  RECORDS delimited by NewLine CHARACTERSET zhs16gbk
  badfile ' extdir ': ' Ldr_case1. Bad '
  LOGFILE ' ldr_case1. Log_xt '
  readsize 1048576
  SKIP 6
  FIELDS terminated by ", optionally enclosed by '" '
  REJECT ROWS with A LL-NULL FIELDS
  (
   "ID" char (255) 
    terminated by ",",
   "NAME" char (255)
    terminated  by ","
  )
 )
 LOCATION
 (
  ' studenttest.csv '
 )
) REJECT LIMIT Unlimited;

3 Execute INSERT INTO Statement Import External table data into a table in library