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'