使用数据泵expdp命令和impdp命令对数据库的数据进行导入导出

本文链接：https://blog.youkuaiyun.com/linux_wang130/article/details/11901601

本文详细介绍如何在 Oracle 数据库中创建目录、授予权限，并通过 EXPDP 和 IMPDP 工具进行数据的导出与导入操作。文章包括了设置环境变量、指定源目标模式等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

初始化环境：
$cd /home/oracle
$mkdir datadump
$pwd
/home/oracle/datadump
$sqlplus / as sysdba
SQL>create directory datadump as '/home/oracle/datadump';
SQL>grant read,write on directory datadump to system;
SQL>alter user system identified by oracle;
SQL>exit;
导出：
$export ORACLE_SID=fumao
$expdp system/oracle directory=datadump dumpfile=FUMAO_ZH.dmp logfile=fumao_zh.log schemas=FUMAO_ZH
$expdp system/oracle directory=datadump dumpfile=FUMAO_EN.dmp logfile=fumao_en.log schemas=FUMAO_EN
$export ORACLE_SID=fm
$expdp system/oracle directory=datadump dumpfile=SERVICE_ZH.dmp logfile=service_zh.log schemas=SERVICE_ZH
$expdp system/oracle directory=datadump dumpfile=SERVICE_EN.dmp logfile=service_en.log schemas=SERVICE_EN
$expdp system/oracle directory=datadump dumpfile=FUMAOBAO.dmp logfile=fumaobao.log schemas=FUMAOBAO
导入：
impdp system/oracle directory=datadump dumpfile=FUMAO_ZH.dmp logfile=fumao_zh_imp.log remap_schema=FUMAO_ZH:FUMAO_ZH table_exists_action=replace
impdp system/oracle directory=datadump dumpfile=FUMAO_EN.dmp logfile=fumao_en_imp.log remap_schema=FUMAO_EN:FUMAO_EN table_exists_action=replace
impdp system/oracle directory=datadump dumpfile=SERVICE_ZH.dmp logfile=service_zh_imp.log remap_schema=SERVICE_ZH:SERVICE_ZH table_exists_action=replace
impdp system/oracle directory=datadump dumpfile=SERVICE_EN.dmp logfile=service_en_imp.log remap_schema=SERVICE_EN:SERVICE_EN table_exists_action=replace
impdp system/oracle directory=datadump dumpfile=FUMAOBAO.dmp logfile=fumaobao_zh_imp.log remap_schema=FUMAOBAO:FUMAOBAO table_exists_action=replace