Oracle SqlLoader Tool

Because a large amount of data exists in text files and needs to be imported to Oracle, we are lucky to have access to the arms SqlLoader.

Run the sqlldr command on the host where Oracle is installed.
Sqlldr

You will see instructions on this tool:

It's just a simple example to help you get in touch for the first time.

Compile a ctl file named input. ctl as the control file of the Oracle database.
Load data
Infile
Append into table B
Fields terminated by C
(
D [COLUMNLIST]
)

Note:
Enter the full or relative path of the input data file at location A in the string format (included)
Enter the table name in the corresponding database at location B (but make sure the table exists and has a correct structure)
Enter the delimiter between data in the text file in section C and use the string format (included)
D. Fill in the field name list corresponding to the text data in the database table. Use "," to separate multiple field names.

If everything is ready, it will be more OK later. Switch the directory to the directory where input. ctl is located and run
Sqlldr userid = username/password @ instanceName control = input. ctl

OK!