ORACLE10g 数据泵应用EMPDP，IMPDP

1.登录oracle创建directory      DPUMP_DIR

SQL> create or replace directory  DPUMP_DIR as  '/oracle/backup/dmp' ;

 

2.授权read,write 权限给导出用户

SQL>grant read ,write on directory  DPUMP_DIR  to 用户名;

 

3.编写导库脚本，expdp_100_fxq.sh 

 

#!/usr/bin/ksh
#. /home/oracle/.profile;
echo "***********************************************";
echo "*  NAME    : expdp_100_fxq.sh                                            *";
echo "*  SUBJECT : FXQ  PRODUCT BACKUP                                   *";
echo "*  DATE    : 2010-01-19                                                        *";
echo "*  AUTHOR  : LIANG WEI                                                       *";
echo "*                                                                                           *";
echo "*                                                                                           *";
echo "***********************************************";

expdpDate=$(date +%Y%m%d);

userid="用户名/密码";
cd /oracle/backup/dmp/
echo "  ***** bakup time ${expdpDate} ******* "
filename="fxq100${expdpDate}.dmp"
expdp ${userid}  directory=dumpdir dumpfile=${filename} job_name=myjob4  logfile=fxq100${expdpDate}.log parallel=4 ;

 

 

4.赋予脚本可执行权限

chmod  700   expdp_100_fxq.sh 

 

 

5.执行expdp_100_fxq.sh 

sh expdp_100_fxq.sh 

 

---

导入脚本如下：

impdpDate=$(date +%Y%m%d);
userid="用户名/密码";
cd /oracle/backup/dmp/
echo "  ***** bakup time ${impdpDate} ******* "
filename="fxq100${impdpDate}.dmp"
impdp ${userid}  directory=dpump_dir  dumpfile=${filename} parallel=4   job_name=myjob4 logfile=fxq100${impdpDate}.log remap_tablespace=CAPRODSP:FXQ