【第008篇】通过dexp和dimp命令导出和导入dmp文件（适用于达梦数据库）
检查数据库版本：
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、执行导出命令：
java
复制代码
dexp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=RENREN FILE=RENREN_DATA_20260704.dmp LOG=RENREN_LOG_20260704.log DIRECTORY=E:/backup
下面语法：
dexp USERID=SYSDBA/密码@B的IP:5236 SCHEMAS=模式名 FILE=schema.dmp LOG=exp.log DIRECTORY=D:\backup
导入dmp文件到数据库中（麒麟系统）
1、将上述导出的文件传输到麒麟系统中，传完文件后，在麒麟系统打开终端，切换到 dmdba 用户操作。
2、导入前先确认目标库里有没有同名模式：
有同名模式：直接执行下面的导入命令。
无同名模式：必须先手动建好表空间和用户，否则会报错。
java
复制代码
/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=RENREN FILE=RENREN_DATA_20260704.dmp LOG=RENREN_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup
语法：
/database/dmsoft/bin/dimp USERID=SYSDBA/密码@localhost:5236 SCHEMAS=模式名 FILE=schema.dmp LOG=imp.log DIRECTORY=/dm8/backup
注意：
/database/dmsoft 指的是麒麟系统中达梦数据库安装的目录。
/dm8/backup 指的是dmp文件上传的目录。
==========================
以下内容是为了自己使用方便，记录的。
sql
复制代码
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-不敏感)
dexp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=RENREN FILE=RENREN_DATA_20260704.dmp LOG=RENREN_LOG_20260704.log DIRECTORY=E:/backup
dexp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=BAIMS FILE=BAIMS_DATA_20260704.dmp LOG=BAIMS_LOG_20260704.log DIRECTORY=E:/backup
dexp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=DATA_MODEL FILE=DATA_MODEL_DATA_20260704.dmp LOG=DATA_MODEL_LOG_20260704.log DIRECTORY=E:/backup
dexp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=DATA_NXSODS FILE=DATA_NXSODS_DATA_20260704.dmp LOG=DATA_NXSODS_LOG_20260704.log DIRECTORY=E:/backup
dexp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=GWPC_HR FILE=GWPC_HR_DATA_20260704.dmp LOG=GWPC_HR_LOG_20260704.log DIRECTORY=E:/backup
dexp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=GWPC_ZD FILE=GWPC_ZD_DATA_20260704.dmp LOG=GWPC_ZD_LOG_20260704.log DIRECTORY=E:/backup
dexp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=NXSODS FILE=NXSODS_DATA_20260704.dmp LOG=NXSODS_LOG_20260704.log DIRECTORY=E:/backup
dexp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=RPA FILE=RPA_DATA_20260704.dmp LOG=RPA_LOG_20260704.log DIRECTORY=E:/backup
dexp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=YWZNGK3_LQ FILE=YWZNGK3_LQ_DATA_20260704.dmp LOG=YWZNGK3_LQ_LOG_20260704.log DIRECTORY=E:/backup
dexp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=YWZNGK3_ZJK FILE=YWZNGK3_ZJK_DATA_20260704.dmp LOG=YWZNGK3_ZJK_LOG_20260704.log DIRECTORY=E:/backup
dexp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=ZCQS3 FILE=ZCQS3_DATA_20260704.dmp LOG=ZCQS3_LOG_20260704.log DIRECTORY=E:/backup
dexp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=ZCQS3_LQ FILE=ZCQS3_LQ_DATA_20260704.dmp LOG=ZCQS3_LQ_LOG_20260704.log DIRECTORY=E:/backup
=================================
/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=RENREN FILE=RENREN_DATA_20260704.dmp LOG=RENREN_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup
/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=BAIMS FILE=BAIMS_DATA_20260704.dmp LOG=BAIMS_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup
/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=DATA_MODEL FILE=DATA_MODEL_DATA_20260704.dmp LOG=DATA_MODEL_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup
/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=DATA_NXSODS FILE=DATA_NXSODS_DATA_20260704.dmp LOG=DATA_NXSODS_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup
/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=GWPC_HR FILE=GWPC_HR_DATA_20260704.dmp LOG=GWPC_HR_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup
/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=GWPC_ZD FILE=GWPC_ZD_DATA_20260704.dmp LOG=GWPC_ZD_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup
/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=NXSODS FILE=NXSODS_DATA_20260704.dmp LOG=NXSODS_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup
/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=RPA FILE=RPA_DATA_20260704.dmp LOG=RPA_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup
/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=YWZNGK3_LQ FILE=YWZNGK3_LQ_DATA_20260704.dmp LOG=YWZNGK3_LQ_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup
/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=YWZNGK3_ZJK FILE=YWZNGK3_ZJK_DATA_20260704.dmp LOG=YWZNGK3_ZJK_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup
/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=ZCQS3 FILE=ZCQS3_DATA_20260704.dmp LOG=ZCQS3_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup
/database/dmsoft/bin/dimp USERID=SYSDBA/DaMeng123@localhost:5236 SCHEMAS=ZCQS3_LQ FILE=ZCQS3_LQ_DATA_20260704.dmp LOG=ZCQS3_LQ_LOG_20260704.log DIRECTORY=/home/dmdba/dm8/backup