-- 切换达梦数据库
 su - dmdba
--创建用户
CREATE USER datalookv8 IDENTIFIED BY datalookv8;
-- 授权
GRANT DBA TO datalookv8;
-- 导出dmp文件
./dexp USERID=datalook/'"Datalook#2021"'@192.168.16.20:5236 FILE=datalook_real.dmp DIRECTORY=/data/dm LOG=exp_datalook_real.log OWNER=datalook
-- 查询导出dmp文件中有那些模式 
./dimp datalookv8/datalookv8@localhost:5236        FILE=/data/dm/datalook_real.dmp        SHOW=Y 2>&1 | head -100
-- 恢复到指定库dmp文件
./dimp datalookv8/datalookv8@localhost:5236  FILE=datalook_real.dmp  DIRECTORY=/data/dm  FROMUSER=DATALOOK  TOUSER=DATALOOKV8