当前位置：首页 > news >正文

【第008篇】通过dexp和dimp命令导出和导入dmp文件（适用于达梦数据库）

news 2026/7/10 22:46:49

检查数据库版本：
select * from v$version;

检查下面参数，两个数据库必须保证一致，才能执行成功。
select SF_GET_PAGE_SIZE();-- 32768
select SF_GET_UNICODE_FLAG();-- 1
select SF_GET_CASE_SENSITIVE_FLAG();-- 1
select CASE_SENSITIVE();-- 查看大小写敏感(1-敏感;0-不敏感)

导出数据库文件成dmp文件：
1、进入达梦数据库安装目录的bin目录：例如，D:\dm8\bin
2、在地址栏中输入cmd命令，进入终端命令窗口。
3、执行导出命令：

dexpUSERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=RENRENFILE=RENREN_DATA_20260704.dmpLOG=RENREN_LOG_20260704.logDIRECTORY=E:/backup 下面语法： dexpUSERID=SYSDBA/密码@B的IP:5236SCHEMAS=模式名FILE=schema.dmpLOG=exp.logDIRECTORY=D:\backup

导入dmp文件到数据库中（麒麟系统）
1、将上述导出的文件传输到麒麟系统中，传完文件后，在麒麟系统打开终端，切换到 dmdba 用户操作。
2、导入前先确认目标库里有没有同名模式：
有同名模式：直接执行下面的导入命令。
无同名模式：必须先手动建好表空间和用户，否则会报错。

/database/dmsoft/bin/dimpUSERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=RENRENFILE=RENREN_DATA_20260704.dmpLOG=RENREN_LOG_20260704.logDIRECTORY=/home/dmdba/dm8/backup 语法：/database/dmsoft/bin/dimpUSERID=SYSDBA/密码@localhost:5236SCHEMAS=模式名FILE=schema.dmpLOG=imp.logDIRECTORY=/dm8/backup 注意：/database/dmsoft 指的是麒麟系统中达梦数据库安装的目录。/dm8/backup 指的是dmp文件上传的目录。

==========================
以下内容是为了自己使用方便，记录的。

select*fromv$version;selectSF_GET_PAGE_SIZE();-- 32768selectSF_GET_UNICODE_FLAG();-- 1selectSF_GET_CASE_SENSITIVE_FLAG();-- 1selectCASE_SENSITIVE();-- 查看大小写敏感(1-敏感;0-不敏感)dexp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=RENRENFILE=RENREN_DATA_20260704.dmp LOG=RENREN_LOG_20260704.log DIRECTORY=E:/backupdexp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=BAIMSFILE=BAIMS_DATA_20260704.dmp LOG=BAIMS_LOG_20260704.log DIRECTORY=E:/backupdexp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=DATA_MODELFILE=DATA_MODEL_DATA_20260704.dmp LOG=DATA_MODEL_LOG_20260704.log DIRECTORY=E:/backupdexp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=DATA_NXSODSFILE=DATA_NXSODS_DATA_20260704.dmp LOG=DATA_NXSODS_LOG_20260704.log DIRECTORY=E:/backupdexp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=GWPC_HRFILE=GWPC_HR_DATA_20260704.dmp LOG=GWPC_HR_LOG_20260704.log DIRECTORY=E:/backupdexp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=GWPC_ZDFILE=GWPC_ZD_DATA_20260704.dmp LOG=GWPC_ZD_LOG_20260704.log DIRECTORY=E:/backupdexp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=NXSODSFILE=NXSODS_DATA_20260704.dmp LOG=NXSODS_LOG_20260704.log DIRECTORY=E:/backupdexp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=RPAFILE=RPA_DATA_20260704.dmp LOG=RPA_LOG_20260704.log DIRECTORY=E:/backupdexp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=YWZNGK3_LQFILE=YWZNGK3_LQ_DATA_20260704.dmp LOG=YWZNGK3_LQ_LOG_20260704.log DIRECTORY=E:/backupdexp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=YWZNGK3_ZJKFILE=YWZNGK3_ZJK_DATA_20260704.dmp LOG=YWZNGK3_ZJK_LOG_20260704.log DIRECTORY=E:/backupdexp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=ZCQS3FILE=ZCQS3_DATA_20260704.dmp LOG=ZCQS3_LOG_20260704.log DIRECTORY=E:/backupdexp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=ZCQS3_LQFILE=ZCQS3_LQ_DATA_20260704.dmp LOG=ZCQS3_LQ_LOG_20260704.log DIRECTORY=E:/backup=================================/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=RENRENFILE=RENREN_DATA_20260704.dmp LOG=RENREN_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=BAIMSFILE=BAIMS_DATA_20260704.dmp LOG=BAIMS_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=DATA_MODELFILE=DATA_MODEL_DATA_20260704.dmp LOG=DATA_MODEL_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=DATA_NXSODSFILE=DATA_NXSODS_DATA_20260704.dmp LOG=DATA_NXSODS_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=GWPC_HRFILE=GWPC_HR_DATA_20260704.dmp LOG=GWPC_HR_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=GWPC_ZDFILE=GWPC_ZD_DATA_20260704.dmp LOG=GWPC_ZD_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=NXSODSFILE=NXSODS_DATA_20260704.dmp LOG=NXSODS_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=RPAFILE=RPA_DATA_20260704.dmp LOG=RPA_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=YWZNGK3_LQFILE=YWZNGK3_LQ_DATA_20260704.dmp LOG=YWZNGK3_LQ_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=YWZNGK3_ZJKFILE=YWZNGK3_ZJK_DATA_20260704.dmp LOG=YWZNGK3_ZJK_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=ZCQS3FILE=ZCQS3_DATA_20260704.dmp LOG=ZCQS3_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236SCHEMAS=ZCQS3_LQFILE=ZCQS3_LQ_DATA_20260704.dmp LOG=ZCQS3_LQ_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup