--查询dmp字符集

cat spmprd_20151030.dmp |od -x|head -1|awk '{print $2 $3}'|cut -c 3-6

select nls_charset_name(to_number('','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;

create user spmprd

  identified by "spmprd"

  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

BJ_FJEPMS_DEV=

  (DESCRIPTION=

    (ADDRESS=

      (PROTOCOL=TCP)

      (HOST=xxxxxxxxxxxx)

      (PORT=1521)

    )

    (CONNECT_DATA=

      (SID=orcl)

    )

  )