刷数据库存的过程
刷数据库存的过程
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'
