Databases Reference
In-Depth Information
In step 4 we observe the last lines of the generated log file. The following screenshot shows
the output of this procedure:
The log states that 115273 rows from the text file were loaded without errors in 3.20 seconds.
In step 5 we truncate the
MY_IMPORT_DATA
table, and in step 6 we execute another
SQL*Loader session, using the same control file and data file, but adding the parameter
DIRECT=TRUE
. The loading process will use direct path loading—the data is loaded using a
mechanism similar to direct path inserting—resulting in the following log, obtained from step 7:
