1、导入:
切换到达梦用户到安转了达梦库的bin目录下执行达梦导入dmp命令:
./dimp BPM/abcd1[email protected]:5236 file=/data/BPM.dmp fromuser=BPM touser=BPM;
例如:
./dimp gxb12381/[email protected]:5236 file=/home/dmdba/gxb12381-20200317.dmp fromuser=gxb12381 touser=gxb12381;
2、导出:
到bin目录下执行达梦导出dmp命令: ./dexp userid=ZJ12315_PX/abcd123456 @192.168.10.140:5236 file=scjg_yanshi.dmp log=ZJ12315_yanshi.log owner=ZJ12315_PX directory=/data;(directory是导出路径跟Oracle好像不一样)
例如:
./dexp userid=gxb12381/[email protected]:5237 file=/home/dmdba/gxb12381-2020032
6.dmp log=/home/dmdba/gxb12381cx-20200326.log owner=gxb12381 directory=/home/dmdba/;