Import data in CVS format to Oracle table

First, you must have a CVS file.

DM	Dmmc	XH	DM1	Dmmc1	Wh	Gbbz	FH	Xgsj	Isdel
1	Male	3							0
2	Female	2							0

 

1. The current working directory is created on drive C.

 

 

2. Create the content of the testxb. CTL file as follows:

Load data
Infile 'C:/xb.csv'
Replace Delete into Table zzdxb fields terminated ','
(DM, dmmc, XH, DM1, dmmc1, wh, gbbz, FH, xgsj, isdel)

 

 

3. "program"-"run"-cmd

Input: sqlldr userid = user name/password @ service name control = 'C:/testxb. CTL'

If the import is successful: No data records exist in the generated bad file.

If the generated bad file has a data record, it indicates that the imported data has a situation.

Tip: reach the submission point-64 logical record count (each 64 records are submitted once)