--querying the DMP character setCat Spmprd_20151030.dmp|Od-X|Head-1|Awk'{print $ $}'|Cut-C3-6SelectNls_charset_name (To_number ('0345','xxxx')) fromDUAL;SPM Completing DMP importing detailed procedures on Windows systemsCreateTablespace spmsit datafile'D:\DATAS\DATA01.dbf'Size 200m Autoextend on Next10m MaxSize Unlimited;CreateTablespace DATA01 datafile'D:\DATAS\DATA01.dbf'Size 200m Autoextend on Next10m MaxSize Unlimited;Create UserSpmdev identified by"Spmdev"defaulttablespace spmsitTemporaryTablespaceTEMP ProfileDEFAULT; GrantConnect,resource,dba toSpmdev; Create UserQueryuser identified by"Queryuser"defaulttablespace spmsitTemporaryTablespaceTEMP ProfileDEFAULT; Create UserSpmquery identified by"Spmquery"defaulttablespace spmsitTemporaryTablespaceTEMP ProfileDEFAULT; environment variable settings import session character Set variable name: Nls_lang variable value: Simplified Chinese_china. Zhs16gbkimp Spmdev/Spmdev@orclFromuser=SPMPRD Touser=Spmdevfile=D:\datas\spmprd_20151030.dmp IGNORE=Y--Import Database TNS Spmdev/spmdevBj_fjepms_dev=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=114.251.247.91) (PORT=1521)) (Connect_data=(SID=ORCL)) )
SPM completes DMP import detailed process on Windows system