导言：

    oracle10g版本新增了数据泵功能，对迁移数据性能很高。

  1. 方法一，通过网络连接导数据

    导入用户需要授权 grant exp_full_database to common; 

impdp tbcs/pass  directory=tbcs network_link=CRM1_TBCS   table_exists_action=REPLACE  ignore=y   logfile=tcrmdb4.log parallel=6 job_name=tcrmdb4tbcs
impdp icdpub/pass directory=tbcs network_link=CRM1_ICDPUB   table_exists_action=REPLACE  ignore=y   logfile=tcrmdb4icd.log parallel=6 job_name=tcrmdb4icdpub
impdp common/pass  directory=tbcs network_link=CRM1_com   table_exists_action=REPLACE  ignore=y   logfile=tcrmdb4com.log parallel=4 job_name=tcrmdb4common 
 2.方法二
mkfifo fifo_tbcs
nohup exp tbcs/pass@net  file=fifo_tbcs log=tbcs.log indexes=y triggers=y constraints=y statistics=none buffer=30720000  &
nohup imp tbcs/pass  file=fifo_tbcs FULL=Y buffer=40960000 constraints=y ignore=y commit=y  &

                                                                                                 信息中心cmo shenlu

                                                                                                         2014-12-01