Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to use SQL Loader in Oracle". In daily operation, I believe many people have doubts about how to use SQL Loader in Oracle. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the questions of "how to use SQL Loader in Oracle". Next, please follow the editor to study!

1. Characteristics of SQL Loader

Oracle brings a lot of tools that can be used for data migration, backup and recovery. But each tool has its own characteristics. For example, exp and imp can export and import the data in the database, which is a good tool for database backup and recovery, so it is mainly used in database hot backup and recovery. It has the advantages of high speed, easy to use and fast; at the same time, it also has some disadvantages, such as problems often occur in the process of exporting and importing between different versions of the database.

However, SQL Loader tool has no such problem. It can import some data stored in text format into Oracle database smoothly. It is a very convenient and universal tool for data migration between different databases. The speed is relatively slow when there are missing points, and it is a bit troublesome for blob and other types of data.

2. SQL Loader's help

Execute the sqlldr command directly under DOS, and the help information for the sqlldr tool will be displayed

3. SQL Loader usage example 3.1. Data import execution steps

(a) insert, which is the default, requires the table to be empty at the beginning of data loading. (B) append, append new records to the table.

(C) replace, delete the old record and replace it with the newly loaded record.

(d) truncate, ibid.

(3) perform import operation

After the control file is created, use the SQL*Loader command to input the data under the DOS window, C:\ > sqlldr userid=scott/tiger control=input.ctl executes the command, the system generates the log file name: input.log by default. The bad record file generated by default is: input.bad.

3.2. EXCEL data Import

Save EXCEL as a file in CSV format, which is a data file separated by a comma (,). And then follow the

The above method is executed.

At this point, the study on "how to use SQL Loader in Oracle" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.