oracle全量备份

1.导出epmssit数据库备份；
exp system/sysadmin@hnepms file=d:\datas\epmssit_bak20100401.dmp owner=epmssit

2.创建epmsprd用户以及表空间；
sqlplus "/as sysdba"
create tablespace epmsprd datafile 'D:\datas\epmsprd.ora' size 100M;
create user epmsprd identified by epmsprd default tablespace epmsprd;
grant resource,connect to epmsprd;

3.将epmssit导入到epmsprd用户；
imp system/sysadmin@hnepms file=d:\datas\epmssit_bak20100401.dmp fromuser=epmssit touser=epmsprd

4.清理epmsprd





数据库中的垃圾数据；

delete from xxxxxx;

5.备份epmsprd；
exp system/sysadmin@hnepms file=d:\datas\epmsprd_bak20100401.dmp owner=epmsprd

alter system set deferred_segment_creation=false;