|
The LOAD TABLE statement lets you efficiently import data into an existing table in text/ASCII formats. The LOAD TABLE statement imports one row per line, with values separated by a delimiter.
Use the LOAD TABLE statement when you want to:
import data in text format
improve performance and can use the LOAD TABLE statement instead of an INPUT statement
For more information, see LOAD TABLE statement.
Changes are not recorded in the transaction log when the LOAD TABLE statement is used, which makes this statement unusable with SQL Remote or MobiLink remote databases. If you need to recover data using the current transaction log and an older copy of the database, recovery fails if the original data file is no longer present.
The LOAD TABLE statement is considerably faster than the INPUT statement.
The LOAD TABLE statement adds the contents of the file to the existing rows of the table; it does not replace the existing rows in the table.