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

最新推荐文章于 2023-09-08 16:24:22 发布

原创最新推荐文章于 2023-09-08 16:24:22 发布 · 838 阅读

0 ·

CC 4.0 BY-SA版权

oracle系统同时被 3 个专栏收录

30 篇文章

订阅专栏

RAC

20 篇文章

订阅专栏

RMAN模块

8 篇文章

订阅专栏

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

部署运行你感兴趣的模型镜像

初始化环境：
$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

您可能感兴趣的与本文相关的镜像