Running ttBulkCp with the -directLoad Option on TimesTen

Run the ttBulkCp utility with the -directLoad option to copy data from an ASCII file into a TimesTen database table.

The -directLoad option loads data with standard INSERT SQL statements. The ttBulkCp -directLoad option can only be used by applications using direct connections, which avoids some of the overhead required when using client/server connections resulting in better performance than the -i option.

For improved performance, consider dropping indexes before loading data with the -directLoad option. Use the ttSchema utility to view the definition of all the indexes that are created on the tables of a TimesTen database. Once the load operation is complete, manually re-create the indexes on your table. See ttSchema in the Oracle TimesTen In-Memory Database Reference.

Note:

Ensure that your TimesTen user has INSERT privilege on the tables it copies information into.

This example copies the data from the employees.dmp file into the hr.employees table of the database1 database using the ttBulkCp -directLoad option.

% ttBulkCp -directLoad -connstr "DSN=database1;UID=HR;PWD=hr" hr.employees employees.dmp

employees.dmp:
    107 rows inserted
    0 duplicate rows not inserted
    107 rows total

See ttBulkCp in the Oracle TimesTen In-Memory Database Reference.