- 论坛徽章:
- 0
|
求教:从win下的db2数据如何导入aix下的db2数据库中
在win下用
db2move cqghj1 export -tn TDAML
把单表导出,但是他的默认路径是c:\db2\bin.请问如何指定路径
在aix中用下面的命令
db2move cqghj1 import 我把前面生成的四个文件放在/home/db2inst1/sqllib/bin下
可提示是错误的命令:
Error opening report file.
我再尝试用下面的命令:
db2move cqghj1 import TDAML 或
db2move cqghj1 import -io TDAML
提示错误:
DB2MOVE
Error: Invalid number of parameters!
Usage: "db2move dbname action [options]"
- Action: must be EXPORT, IMPORT, or LOAD.
- Options: If not specified, defaults will be used.
Option Default Notes
==========================================================================
-tc table-creators all creators EXPORT. Wildcard (*) allowed.
-tn table-names all user tables EXPORT. Wildcard (*) allowed.
-io import-option REPLACE_CREATE IMPORT only.
-lo load-option INSERT LOAD only.
-l lobpaths current dir separated by commas. NO BLANKS.
-u userid logged on userid
-p password logged on password
请问到底该如何打命令,详细点 |
|