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