timsten -ttBulkCp

I need to insert million of records from flat file,

ttBulkCp -i C:\TimesTen\Database\test.txt

what cmd i need to give ?

i am having the txt file in C:\TimesTen\Database\test.txt
i need to import into my_ttdb database which is placed at C:\TimesTen\Database\my_ttdb.ds0/my_ttdb.ds1/my_ttdb.inval

Thanks

Re: Bulk insert -ttBulkCp
发布: 2012-6-14 上午3:30   回复： 933663

回复

the documentation is here:

http://docs.oracle.com/cd/E21901_01/doc/timesten.1122/e21643/util.htm#autoId7

Your command line would look something like this:

ttBulkCp -i DSN=my_ttdb your_table_name C:\TimesTen\Database\test.txt -xp 1000

With a million rows you want to break the insert down with commits say every 1000 rows with the -xp option

Re: Bulk insert -ttBulkCp
发布: 2012-6-14 上午4:15   回复： Tim Vincent

回复

I am getting below error

My table name is test and i am having test.txt file in C:\TimesTen\Database\

Command> ttBulkCp -i DSN=my_ttdb test C:\TimesTen\Database\test.txt;
1001: Syntax error in SQL statement before or at: "TTBULKCP", character positio
n: 1
ttBulkCp -i DSN=my_ttdb test C:\TimesTen\Database\test.txt
^^^^^^^^

Thanks!

Re: Bulk insert -ttBulkCp
发布: 2012-6-14 上午4:42   回复： 933663

回复

Hi 933663,

ttBulkCp - it is not a ttisql command, it is a utility. You should run it on OS level.

For example, run the following in command line (in Windows)

ttBulkCp -i DSN=my_ttdb test C:\TimesTen\Database\test.txt

Regards,
Gennady

Re: Bulk insert -ttBulkCp
发布: 2012-6-18 下午10:10   回复： Gennady Sigalaev

回复

Hi,

I am not able to insert the data i am getting the below error

TimesTen error code = 6220
TimesTen error code = 802

I have created setup of dsn as per the below path

C:\TimesTen\tt1122_32\quickstart\html\admin\dsn_setup_windows.html

Command> connect "dsn=my_ttdb";

Connection successful: DSN=my_ttdb;UID=********;DataStore=C:\TimesTen\Database\my_ttdb;
DatabaseCharacterSet=AL32UTF8;ConnectionCharacterSet=US7ASCII;
DRIVER=C:\TimesTen\TT1122~1\bin\ttdv1122.dll;
LogDir=D:\TimesTen\Log;PermSize=40;TempSize=32;TypeMode=0;OracleNetServiceName=orcl_db;(Default setting AutoCommit=1)

Insertion

1st time

C:\>ttBulkCp -i DSN=my_ttdb mytable C:\TimesTen\Database\test2.txt

C:\TimesTen\Database\test2.txt:
100000 rows inserted
100000 rows total

2nd time

C:\>ttBulkCp -i DSN=my_ttdb mytable C:\TimesTen\Database\test2.txt
ttBulkCp: Error received in file C:\TimesTen\Database\test2.txt, line 97280 -- S1000: [TimesTen][TimesTen 11.2.2.2.0 ODBC Driver][TimesTen]TT0802: Database permanent space exhausted -- file "blk.c", lineno 3450, procedure "sbBlkAlloc" (TimesTen error code = 802).

ttBulkCp: Error received in file C:\TimesTen\Database\test2.txt, line 97280 -- S1000: [TimesTen][TimesTen 11.2.2.2.0 ODBC Driver][TimesTen]TT6220: Permanent data partition free space insufficient to allocate 42440 bytes of memory -- file "blk.c", lineno 3450, procedure "sbBlkAlloc" (TimesTen error code = 6220).

how to resolve it

Thanks!

Re: Bulk insert -ttBulkCp
发布: 2012-6-19 上午6:53   回复： 933663

回复

Dear 933663,

You should increase the permanent partition size (PermSize attribute).

Best regards,
Gennady