TimeTen 自带各程序 测试--ttBulkCp

ttBulkCp 将数据导出成文本文件,并还原
     c:>ttbulkcp -o mytest dsmp.a
##ttBulkCp:DATEMODE=TIMESTAMP
#
# DSMP.A, 3 columns, dumped Thu May 08 10:46:57 2008
# columns:
#      1. ID           NUMBER(38)
#      2. NAME         VARCHAR2(20 BYTE)
#      3. C            DATE
# end
#

1,"1",2008-05-05 11:31:17
1,"a",2008-05-05 13:11:15
1,"a",2008-05-05 13:11:23
1,"a",2008-05-05 13:11:34
1,"a",2008-05-05 13:11:39
1,"a",2008-05-05 13:11:43
1,"a",2008-05-05 13:14:44
1,"a",2008-05-05 13:14:48
# 8/8 rows copied

恢复可以直接将上面的文本恢复成数据表