1、从生产库上导出标准格式(username_YYYYMMDD.dmp)的备份 edw_exp_date.sh DATE=`date +%Y%m%d`;export DATE exp edw/edw file=/ODS-DATA/DW_DMP/edw_$DATE.dmp log=/ODS-DATA/DW_DMP/edw_exp_$DATE.log OWNER=edw 2、用ftp或U盘将备份传到测试库 根据环境不同,采用合适的方式 3、重建测试环境用户 create_edw.sh sqlplus bdw/bdw<<! drop user EDW cascade; create user EDW identified by EDW default tablespace BDW temporary tablespace TEMP profile DEFAULT; grant connect to EDW;