2013年3月6日 星期三

Oracle Database - 用export backup 特定table/tablespaces



--Backup 特定table

exp system/xxxxxxxx tables=simctl.F0092,simctl.F9000,simctl.F9001,simctl.F9002,simctl.F9005,simctl.F9005D,simctl.F9006,simctl.F9006D file=simctl_menu.exp log=exp_simctl_menu.log

--Backup 特定tablespaces
day=`date +%Y-%m-%d`
exp system/xxxxxxxx tablespaces=DEV_MDS,DEV_IAS_TEMP,DEV_BIPLATFORM,BIEE_BIPLATFORM,BIEE_MDS,BIEE_IAS_TEMP,BIEE_ODI_TEMP,BIEE_ODI_USER file=biee_$day.exp log=exp_biee_$day.log




沒有留言:

張貼留言