dumpDir='/usr/lib/oracle/12.2/client64/bin' cd $dumpDir DBNameArr=('BEIJING_PMS_20200520' 'HUNAN') for DBName in ${DBNameArr[*]} do dumpFileName=$DBName"-"$dumpDate; echo $DBName expdp sys/~1q2w3e4r@ORCLPDB1 schemas=$DBName dumpfile=$dumpFileName.dmp directory=oracle_base; done expdp eagle2_nc/eagle2_nc@192.168.0.26/orcl schemas=eagle2_nc dumpfile=eagle2_nc.dmp directory=exp_dir ; ./expdp backupdb/backupdb@localhost:11521/ORCLPDB1 schemas=BEIJING_PMS_20200520 dumpfile=BEIJING.dmp directory=oracle_base ; ./expdp sys/~1q2w3e4r@ORCLPDB1 schemas=BEIJING dumpfile=BEIJING.dmp directory=data_dir ; #sql plus 登录 #./sqlplus sys/~1q2w3e4r@192.168.0.143:11521/ORCLPDB1 as sysdba # create directory data_dir as '/backpack'; #expdp sys/~1q2w3e4r@ORCLPDB1 dumpfile=BEIJING.dmp directory=data_dir full=y # ./expdp sys/~1q2w3e4r directory=my_dir dumpfile=BEIJING.dmp schemas=BEIJING #DBName="BEIJING"; # #echo $DBName; #dumpDate=$(date "+%Y-%m-%d") # #dumpFileName=$DBName"-"$dumpDate; # #echo $dumpFileName #expdp scott/tiger@orcl schemas=scott dumpfile=expdp.dmp directory=dump_dir;
oracle dump 问题
最新推荐文章于 2023-09-28 14:25:16 发布