2008-5-8 10:20
jidongzheng
TimeTen 自带各程序 测试--ttMigrate
ttMigrate
导出成一个文件
示例:
c:>ttmigrate -c mytest dsmp.a
Saving table DSMP.A
Saving rows...
8/8 rows saved.
Table successfully saved.
Saving cache group DSMP.CG_READONLY_DEPT_EMP
Saving cached table DSMP.UAPROF
Cache group successfully saved.
完成后,会生成一个文件dsmp.a文件
恢复:
c:>ttmigrate -r mytest dsmp.a
Restoring table DSMP.A
* Warning: lock conflict error while creating table DSMP.A ... retrying.
* Warning: lock conflict error while creating table DSMP.A ... retrying.
Restoring rows...
8/8 rows restored.
Table successfully restored.
Restoring cache group DSMP.CG_READONLY_DEPT_EMP
Restoring cached table DSMP.UAPROF
ttmigrate: Error received while restoring cache group DSMP.CG_READONLY_DEPT_EMP -- S1000: [TimesTen][TimesTen 7.0.
5.0.0 ODBC Driver][TimesTen]TT5213: Bad Oracle login error in OCISessionBegin(): ORA-01017: invalid username/passw
ord; logon denied rc = -1 -- file "bdbConnect.c", lineno 2059, procedure "ttBDbConnect()" (TimesTen error code = 5
213).
ttmigrate: Error received while restoring cache group DSMP.CG_READONLY_DEPT_EMP -- S1000: [TimesTen][TimesTen 7.0.
5.0.0 ODBC Driver][TimesTen]TT5131: Cannot connect to Oracle database: connect_string = "vasomcdb_245", uid = "DSM
P", pwd is hidden -- file "bdbConnect.c", lineno 2061, procedure "ttBDbConnect()" (TimesTen error code = 5131).
1/1 cached table restored.
Cache group successfully restored.