Oracle LOAD batch writes data to the production line database only has query permission. You need to import 50 million pieces of data to the R & D line under the production line. The following tips may accelerate the import speed. 1. connect to the database using PL/SQL, execute the query statement, and export the data in csv format. 2. create a control file: input. ctl Java code www.2cto.com load data infile 'f: \ Users \ xxxxx \ Desktop \ aa \ tt.csv 'truncate -- operation type, use truncate table to clear the original record into table OS _BATCH_USER_his
Fields terminated by "," -- use "," to separate Optionally enclosed by '"' -- start with" for each field in the data, for example ", "-- trailing nullcols when the Delimiter is used -- when the table field does not have the corresponding value, it can be null (id FILLER, -- this is a virtual field, used to skip the first column name generated by PL/SQL Developer, createtime DATE "YYYY-MM-DD HH24: MI: SS") www.2cto.com 3. run the following command on the cmd command line: Java code sqlldr userid = xxxxxx/xxxxxx @ xxxxxx control = e: \ test \ load. ctl log = e: \ test \ 1.log skip = 1 speed. if an error occurs, check the log file e: \ test \ 1.log. skip = 1 indicates skipping the header of the first line.