Using Oracle SQL Loader to bulk import data

One of the most important preparations in performance testing is preparing test data. Before performing a performance test, make sure that you have enough data in your test database to test it. For data preparation, sometimes I use LoadRunner to generate the appropriate script to prepare the data, which has one advantage is simple, but it has a big drawback is that the efficiency is too slow, when we need the amount of data, this is very time-consuming, So I think we need to master a variety of different skills to accomplish this task. Here are some of the lessons I learned in a recent test:

Using Oracle SQL Loader to bulk import data is useful when preparing test data! ）

Excel file to generate test data, save Excel file as CSV (comma-delimited) (*.csv), control file set to comma separated

Example:

LOAD DATA
INFILE ‘d：\car.csv’
APPEND　INTO TABLE t_car_temp
FIELDS TERMINATED BY "，"
（phoneno，vip_car）

Save As Input.ctl

At the end of the command line, enter:

C:\>sqlldr Userid=system/manager

Control=input.ctl (same in UNIX environment)

The default log file name is: Input.log

Default bad record file is: Input.bad