TimesTen 文本数据导入导出.doc

TimesTen 文本数据导入导出 youhongmin@ 工具名: ttBulkCp 一般放在ttinstall/bin下面 用法 有两种模式,-o 表示输出,-i 表示输入 下面通过例子说明基本的用法: 1、建表，插入数据 假设DSN=ZW 先建一张表用于测试,名称定为customer_for_test,建表的语法与ORACLE一样 TT:/home/timesten# ttisql DSN=ZW Command CREATE TABLE customer_for_test (cust_number integer not null primary key, first_name char (12) not null, last_name char (12) not null, address varchar (100) not null); Command desc customer_for_test ; Table TEST.CUSTOMER_FOR_TEST: Columns: *CUST_NUMBER NUMBER (38) NOT NULL FIRST_NAME CHAR (12) NOT NULL LAST_NAME CHAR (12) NOT NULL ADDRESS VARCHAR2 (100) INLINE NOT NULL 1 table found. (primary key columns are indicated with *) Command insert into customer_for_test values(123,aaa,aaab,street aaa bbb); 1 row inserted. Command insert into customer_for_test values(124,abb,aaab,street aaa bbb); 1 row inserted. Command select * from customer_for_test; 123, aaa , aaab , street aaa bbb 124, abb , aaab , street aaa bbb 至此，准备工作已经完成 2、导出 下面试试导出，其中-s参数用于指定分隔符. TT:/home/timesten# ttBulkCp -o -s | DSN=ZW CUSTOMER_FOR_TEST CUSTOMER_FOR_TEST.TXT 2/2 rows copied TT:/home/timesten# cat CUSTOMER_FOR_TEST.TXT2 ##ttBulkCp:FSEP=| # # TEST.CUSTOMER_FOR_TEST, 4 columns, dumped Tue Jan 15 10:58:24 2008 # columns: # 1. CUST_NUMBER NUMBER(38) # 2. FIRST_NAME CHAR(12 BYTE) # 3. LAST_NAME CHAR(12 BYTE) # 4. ADDRESS VARCHAR2(100 BYTE) # end # 123|aaa |aaab |street aaa bbb 125|aaa |aaab |street aaa bbb # 2/2 rows copied TT:/home/timesten# 3、导入 导入的时候，可以在文本头部指定一些信息，例如分隔符 FSEP，对于由ttbulkCp导出来的数据，不需要进行特别的设置，因为在输出的时候，已经把这些信息设置好了。 TT:/home/timesten# cat CUSTOMER_FOR_TEST.TXT ##ttBulkCp:FSEP=$ # TEST.CUSTOMER_FOR_TEST, 4 columns, dumped Tue Jan 15 10:29:49 2008 # columns: # 1. CUST_NUMBER NUMBER(38) # 2. FIRST_NAME CHAR(12 BYTE) # 3. LAST_NAME CHAR(12 BYTE) 123$aaa $aaab