How to use oracle SQL loader to import data in batches

You can see this article on scid.ArticleFor ORACLE data import, the method is simple and effective, and it is useful for data preparation for performance testing, so let's take a look.

Before you perform a performance test, make sure that there is sufficient data required for testing in the test database. For data preparation, sometimes I will use LoadRunner to generate the corresponding script to prepare the data. This method has the advantage of being simple and easy to use. However, it has a major drawback that the efficiency is too slow, when we need a large amount of data, this is very time-consuming, so I think we still need to master a variety of skills to complete this task. The following are my experiences in a recent test:

Use Oracle SQL loader to import data in batches (useful when preparing test data !)

Generate an Excel file for the test data, save the Excel file as CSV (separated by commas) (*. CSV), and set the control file to be separated by commas.

Example:

Load data
Infile 'd: \ car.csv'
Append into Table t_car_temp
Fields terminated ","
(Phoneno, vip_car)

Save as input. CTL

Finally, enter the following command line:

C: \> sqlldr userid = system/Manager
Control = input. CTL (same in UNIX environment)
The default log file name is input. log.
The default bad record file is input. Bad.
 

Transferred from CCID