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