oracle Expdp和impdp

create directory expdp_dir as '/backup/';
Grant read,write on directory expdp_dir to system;

[oracle@project backup]$ vi ./exp_pnet.scr                         
/home/oracle/.bash_profile
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export NLS_LANG='AMERICAN.AL32UTF8'
export ORACLE_SID=XE
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
rq=`date +"%A"`
rq_log=`date +"%Y%m%d"`
$ORACLE_HOME/bin/expdp  system/password full=y directory=expdp_dir dumpfile=full_$rq.dmp logfile=$rq_log\_full.log
chmod 777 /wasbackup/bakfortape/projectnet/
mv /backup/full_$rq.dmp /wasbackup/bakfortape/projectnet/
mv /backup/$rq_log\_full.log /wasbackup/bakfortape/projectnet/

 

SQL>create or replace directory DATA_DIR as '/opt';

SQL>grant read,write on directory DATA_DIR to system;

SQL>commit;

 

[oracle@oracle ~]$ export NLS_LANG='AMERICAN.AL32UTF8'

[oracle@oracle ~]$ cd /opt

[oracle@oracle~]$impdp system/oracle full=y directory=DATA_DIR dumpfile=full_1.dmp