--赋予导入的权限
GRANT imp_full_databse to wechat;
grant read,write on directory dir_dp;




--建立用户默认的表空间和临时表空间
CREATE TABLESPACE DATA0101 DATAFILE 
  'F:\APP\ADMINISTRATOR\ORADATA\WECHAT\DATA0101.DBF' SIZE 5G AUTOEXTEND OFF
LOGGING
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;




CREATE TEMPORARY TABLESPACE WECHAT_TEMP TEMPFILE 
  'F:\APP\ADMINISTRATOR\ORADATA\WECHAT\WECHAT_TEMP.DBF' SIZE 1G AUTOEXTEND OFF
TABLESPACE GROUP ''
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;


--创建相关用户
create user UAT1 IDENTIFIED BY UAT1
  default tablespace DATA0101
  temporary tablespace WECHAT_TEMP
  profile DEFAULT
  password expire;
-- Grant/Revoke object privileges 
grant execute on LOAD_TMP_WEIXIN to UAT1;
grant execute on PROC_TMP_WEIXIN to UAT1;
-- Grant/Revoke role privileges 
grant connect to UAT1;






create user WECHAT IDENTIFIED BY WECHAT
  default tablespace DATA0101
  temporary tablespace WECHAT_TEMP
  profile DEFAULT
  password expire;




create user WEIXIN1 IDENTIFIED BY WEIXIN1
  default tablespace DATA0101
  temporary tablespace WECHAT_TEMP
  profile DEFAULT
  password expire;