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.

  • As the direct path load function exclusively locks the table in a dedicated session, if you intend to also execute processing by using SQL statement before beginning or SQL statement after ending normally, note the following points:

    • If you intend to also execute SQL statement before beginning for the same table, you must execute COMMIT in SQL statement before beginning

    • If you intend to also use SQL statement after ending normally, you cannot execute a SQL statement for the same table