oracle11g- expdp/impdp

windows环境---expdp/impdp
创建导出导入目录及设置权限

cmd> sqlplus sys/123456@999 sysdba

（检查目录字典SELECT * FROM dba_directories;）
SQL> create directory impdp_dir as 'e:\oracle\dump';
SQL> grant read,write on directory expdp_dir to dlerp;
（查看目录权限 SELECT * FROM dba_tab_privs where table_name='IMPDP_DIR';）

检查导入环境字符集（针对imp/exp）保证导入导出数据库的字符集一致
cmd
echo %nls_lang%  
set NLS_LANG=American_America.AL32UTF8（linux-----export NLS_LANG=American_America.AL32UTF8）


impdp dlerp/dlerp@orcl directory=impdp_dir dumpfile=expdp20111111.dmp logfile=impdp20111113.log