Registering by using the Oracle direct path load function

You can now register (INSERT) multiple records in a batch by using the Oracle direct path load function. This function enables you to register a large amount of data more quickly.

To use the Oracle direct path load function, select the INSERT by using direct path loading function check box on the Database Table - Detailed Information screen.

The connected database must meet the use condition for the direct path load function. For details about the use conditions and restrictions of the direct path load function, see the Oracle documentation.

Note

  • In a direct path load, if an INSERT is performed on a table without checking whether the PRIMARY KEY constraint is specified, the primary key might be duplicated. If the primary key is duplicated, a warning is output to the trace log. If this warning is output to the trace log, delete any data that includes duplicate primary keys from the target table.

  • In a direct path load, the output-destination table is exclusively locked during data processing. Therefore, if there is a transaction for another session operating on the same output destination table, an error occurs during the initial processing of the direct path load. If you want to use a direct path load in data processing, do so at a time when no transactions for other sessions occur.

  • INSERT by using direct path load uses two sessions when connecting. Adjust the number of sessions on the database side, if necessary.