Can be achieved: fast import of large amounts of data
1.First install the Oracle client machine. It’s a little big, 600M+,
2.Select Administrator Installation for Installation (1.1g)
3.In the third step, I made a mistake. It was said that the verification of environment variables failed. It was not solved after checking the length of environment variables and whether they had administrator privileges. Considering that this is only for importing data, I choseAll errors are ignored.Finally, it automatically adds environmental variables… for reasons unknown.
4.Just make sure that sqlldr can be used in cmd.
5.Start preparing to import data:
1.Create a new TXT file, and then change TXT to. CTL
2.Open the CTL file and copy the following code: My CTL file name is sqlload. CTL
LOAD DATA infile 'e:\aa.csv' ## Source file path, path does not include ChineseIn table xx_temp# to import tables(ID terminated by whitespace#id as column nameWhitespace represents the use of spaces between columns to distinguish, if any, '|’ The method uses terminated by'|' A comma is a comma, and so on.)
3.After saving, open the console. In the console enter:
sqlldr username/password@ipOr domain name:port/sid control=sqlload.ctl log=sqlload.out
The log file is here at log = sqlload. out. If not specified, the default directory is the same as the CTL directory. The log is mainly used to see the exception information and imported information.
Original articles, reprinted to indicate the source.