ttBulkCp 将数据导出成文本文件,并还原
c:>ttbulkcp -o mytest dsmp.a
##ttBulkCp ATEMODE=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
恢复可以直接将上面的文本恢复成数据表
TimeTen 自带各程序 测试--ttBulkCp
最新推荐文章于 2019-02-25 13:43:55 发布