刷数据库存的过程

		
刷数据库存的过程
 
1. sqlplus / as sysdba
2. lsnrctl stop
3. shutdown immediate
4. startup
5. drop user cisadm cascade;
6. create user cisadm identified by cisadm default tablespace cists_01;
7. 创建与检查目录
 select * from dba_directories;
 如果dump_dir不存在：dump_dir
 create directory dump_dir as 'G:/dump_dir';
 grant read,write on directory dump_dir to cisadm;
8.grant dba to cisadm;
9.lsnrctl start
10.impdp cisadm/cisadm@lzprodb 
directory=dump_dir2 
dumpfile=LZPRODB1.DMP,
LZPRODB2.DMP,LZPRODB3.DMP,
LZPRODB4.DMP,LZPRODB5.DMP,
LZPRODB6.DMP,LZPRODB7.DMP,
LZPRODB8.DMP,LZPRODB9.DMP,
LZPRODB10.DMP 
exclude=table:like\ '%2008%',
exclude=table:like\ '%2009%',
exclude=table:like\ '%2010%',
exclude=table:like\ '%2011%',
exclude=table:like\ '%2012%' schemas='CISADM'
 
						
		
	

上一个：Oracle巡检工具：RDA使用简介
下一个：orcl创建用户赋予权限