spm完成dmp在windows系统上导入详细过程

--查询dmp字符集
cat spmprd_20151030.dmp |od -x|head -1|awk ‘{print $2 $3}‘|cut -c 3-6
select nls_charset_name(to_number(‘0345‘,‘xxxx‘)) from dual;

spm完成dmp在windows系统上导入详细过程

create tablespace SPMSIT datafile ‘D:\DATAS\DATA01.dbf‘ size 200m autoextend on next 10m maxsize unlimited;

create tablespace DATA01 datafile ‘D:\DATAS\DATA01.dbf‘ size 200m autoextend on next 10m maxsize unlimited;

create user spmdev
  identified by "spmdev"
  default tablespace SPMSIT
  temporary tablespace TEMP
  profile DEFAULT;
  
grant connect,resource,dba to spmdev;
  
create user queryuser
  identified by "queryuser"
  default tablespace SPMSIT
  temporary tablespace TEMP
  profile DEFAULT;
  
create user spmquery
  identified by "spmquery"
  default tablespace SPMSIT
  temporary tablespace TEMP
  profile DEFAULT;
  
环境变量设置导入session字符集
变量名：NLS_LANG
变量值：SIMPLIFIED CHINESE_CHINA.ZHS16GBK

imp spmdev/spmdev@orcl fromuser=spmprd touser=spmdev file=D:\datas\spmprd_20151030.dmp IGNORE=Y

--导入数据库tns spmdev/spmdev
BJ_FJEPMS_DEV=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=114.251.247.91)
      (PORT=1521)
    )
    (CONNECT_DATA=
      (SID=orcl)
    )
  )