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

检查数据库版本select * from v$version;检查下面参数两个数据库必须保证一致才能执行成功。select SF_GET_PAGE_SIZE();-- 32768select SF_GET_UNICODE_FLAG();-- 1select SF_GET_CASE_SENSITIVE_FLAG();-- 1select CASE_SENSITIVE();-- 查看大小写敏感(1-敏感;0-不敏感)导出数据库文件成dmp文件1、进入达梦数据库安装目录的bin目录例如D:\dm8\bin2、在地址栏中输入cmd命令进入终端命令窗口。3、执行导出命令dexpUSERIDSYSDBA/DaMeng123localhost:5236SCHEMASRENRENFILERENREN_DATA_20260704.dmpLOGRENREN_LOG_20260704.logDIRECTORYE:/backup 下面语法 dexpUSERIDSYSDBA/密码B的IP:5236SCHEMAS模式名FILEschema.dmpLOGexp.logDIRECTORYD:\backup导入dmp文件到数据库中麒麟系统1、将上述导出的文件传输到麒麟系统中传完文件后在麒麟系统打开终端切换到 dmdba 用户操作。2、导入前先确认目标库里有没有同名模式有同名模式直接执行下面的导入命令。无同名模式必须先手动建好表空间和用户否则会报错。/database/dmsoft/bin/dimpUSERIDSYSDBA/DaMeng123localhost:5236SCHEMASRENRENFILERENREN_DATA_20260704.dmpLOGRENREN_LOG_20260704.logDIRECTORY/home/dmdba/dm8/backup 语法/database/dmsoft/bin/dimpUSERIDSYSDBA/密码localhost:5236SCHEMAS模式名FILEschema.dmpLOGimp.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 USERIDSYSDBA/DaMeng123localhost:5236SCHEMASRENRENFILERENREN_DATA_20260704.dmp LOGRENREN_LOG_20260704.log DIRECTORYE:/backupdexp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASBAIMSFILEBAIMS_DATA_20260704.dmp LOGBAIMS_LOG_20260704.log DIRECTORYE:/backupdexp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASDATA_MODELFILEDATA_MODEL_DATA_20260704.dmp LOGDATA_MODEL_LOG_20260704.log DIRECTORYE:/backupdexp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASDATA_NXSODSFILEDATA_NXSODS_DATA_20260704.dmp LOGDATA_NXSODS_LOG_20260704.log DIRECTORYE:/backupdexp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASGWPC_HRFILEGWPC_HR_DATA_20260704.dmp LOGGWPC_HR_LOG_20260704.log DIRECTORYE:/backupdexp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASGWPC_ZDFILEGWPC_ZD_DATA_20260704.dmp LOGGWPC_ZD_LOG_20260704.log DIRECTORYE:/backupdexp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASNXSODSFILENXSODS_DATA_20260704.dmp LOGNXSODS_LOG_20260704.log DIRECTORYE:/backupdexp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASRPAFILERPA_DATA_20260704.dmp LOGRPA_LOG_20260704.log DIRECTORYE:/backupdexp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASYWZNGK3_LQFILEYWZNGK3_LQ_DATA_20260704.dmp LOGYWZNGK3_LQ_LOG_20260704.log DIRECTORYE:/backupdexp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASYWZNGK3_ZJKFILEYWZNGK3_ZJK_DATA_20260704.dmp LOGYWZNGK3_ZJK_LOG_20260704.log DIRECTORYE:/backupdexp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASZCQS3FILEZCQS3_DATA_20260704.dmp LOGZCQS3_LOG_20260704.log DIRECTORYE:/backupdexp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASZCQS3_LQFILEZCQS3_LQ_DATA_20260704.dmp LOGZCQS3_LQ_LOG_20260704.log DIRECTORYE:/backup/database/dmsoft/bin/dimp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASRENRENFILERENREN_DATA_20260704.dmp LOGRENREN_LOG_20260704.log DIRECTORY/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASBAIMSFILEBAIMS_DATA_20260704.dmp LOGBAIMS_LOG_20260704.log DIRECTORY/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASDATA_MODELFILEDATA_MODEL_DATA_20260704.dmp LOGDATA_MODEL_LOG_20260704.log DIRECTORY/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASDATA_NXSODSFILEDATA_NXSODS_DATA_20260704.dmp LOGDATA_NXSODS_LOG_20260704.log DIRECTORY/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASGWPC_HRFILEGWPC_HR_DATA_20260704.dmp LOGGWPC_HR_LOG_20260704.log DIRECTORY/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASGWPC_ZDFILEGWPC_ZD_DATA_20260704.dmp LOGGWPC_ZD_LOG_20260704.log DIRECTORY/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASNXSODSFILENXSODS_DATA_20260704.dmp LOGNXSODS_LOG_20260704.log DIRECTORY/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASRPAFILERPA_DATA_20260704.dmp LOGRPA_LOG_20260704.log DIRECTORY/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASYWZNGK3_LQFILEYWZNGK3_LQ_DATA_20260704.dmp LOGYWZNGK3_LQ_LOG_20260704.log DIRECTORY/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASYWZNGK3_ZJKFILEYWZNGK3_ZJK_DATA_20260704.dmp LOGYWZNGK3_ZJK_LOG_20260704.log DIRECTORY/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASZCQS3FILEZCQS3_DATA_20260704.dmp LOGZCQS3_LOG_20260704.log DIRECTORY/home/dmdba/dm8/backup/database/dmsoft/bin/dimp USERIDSYSDBA/DaMeng123localhost:5236SCHEMASZCQS3_LQFILEZCQS3_LQ_DATA_20260704.dmp LOGZCQS3_LQ_LOG_20260704.log DIRECTORY/home/dmdba/dm8/backup