--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
沒有留言:
張貼留言