招商数据库导入

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

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

impdp cosem/***@localhost:1521/orcl file="E:\app\denghy\oradata\orcl\bak\COSEM20180318.DMP" full = y;
文件保存到E:\oracle\app\fenyu8\oradata\orcl\COSEM20180318.DMP
impdp cosem/***@localhost:1521/orcl file="‪‪MW20190619.DMP" full = y;

#imp cosem/***@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/***@orcl schemas=cosem dumpfile=MW20190619.dmp