Running ttBulkCp with the -i Option

The ttBulkCp utility with the -i option enables you to load data from a file.

This option uses standard INSERT SQL statements to load data into a specific table of a TimesTen database.

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 -i mode.

% ttBulkCp -i -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 Oracle TimesTen In-Memory Database Reference.