招商数据库导入

cmd.exe
sqlplus /nolog
conn system/FenYu200
登陆指定实例conn system/FenYu200@localhost:1521/orcl1

create tablespace SH datafile ‘D:\app\Administrator\oradata\liugm\SH.dbf’  size 50m autoextend on next 50m maxsize 4000m extent management local; 
create tablespace CHSHR datafile ‘D:\app\Administrator\oradata\liugm\CHSHR.dbf’  size 50m autoextend on next 50m maxsize 4000m extent management local; 
create tablespace OA datafile ‘D:\app\Administrator\oradata\liugm\OA.dbf’  size 50m autoextend on next 50m maxsize 4000m extent management local; 
create user cosem identified by sa default tablespace SH;
grant dba to cosem;
create user COSEMGUEST identified by sa;
create user MWPMS identified by sa;
create user COSEMFORSQEMS identified by sa;
create user MDMUSER identified by sa;
create user CMESAPP identified by sa;
create user BVM identified by sa;

impdp cosem/sa@localhost:1521/liugm file=“D:\app\Administrator\oradata\liugm\MW20190712.DMP” full = y;
文件保存到E:\oracle\app\fenyu8\oradata\orcl\COSEM20180318.DMP
impdp cosem/sa@localhost:1521/orcl file=“‪‪MW20190619.DMP” full = y;

#imp cosem/sa@localhost:1521/orcl file=D:\app\cosco\admin\orcl\dpdump\bunker20190623.dmp full=y

导入之后一定要执行下面的脚本，否则，调试的时候会乱发邮件的。update xt_user set password =‘e10adc3949ba59abbe56e057f20f883e’;
update xt_userprofile set email = ‘’ ;

drop user cosem cascade;
drop user COSEMGUEST cascade;
drop user MWPMS cascade;
drop user COSEMFORSQEMS cascade;
drop user MDMUSER cascade;
drop user CMESAPP cascade;
drop user BVM cascade;
drop tablespace SH including contents and datafiles;
drop tablespace CHSHR including contents and datafiles;
drop tablespace OA including contents and datafiles;

expdp cosem/sa@orcl schemas=cosem dumpfile=MW20190619.dmp