oracle exp/expdp imp/impdp

exp 与expdp的区别

expdp 时报如下错误

ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name DATA_PUMP_DIR is invalid

 

 

主要是权限问题授权给该用户：

grant read,write on directory data_pump_dir to posmadm;

 

data_pump_dir的建立

CREATE DIRECTORY data_pump_dir AS '/usr/dba/dpumpfiles':

查看

select * from dba_directories;select * from dba_directories;

 

删除

drop directory exp_dir;

 

 
   expdp user/passwd tables=tablename DIRECTORY=data_pump_dir DUMPFILE=xxxx.dmp

   exp user/passwd  file=~/tablename.dmp  tables=tablename query=\" where logdat='20130301'\"

 

   impdp user/passwd directory=import_dir dumpfile=tablename.dmp
   impdp user/passwd directory=import_dir dumpfile=tablename.dmp

 

exp 如下错误

EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.

主要是因为当前执行exp 命令的环境中没有或设置了和DB 不一样的NLS_LANG 环境变量，解决方法：

SQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';

PARAMETER            VALUE
-------------------- --------------------
NLS_CHARACTERSET     AL32UTF8

[oracle@posphoutai1 ~]$ export NLS_LANG=american_america.AL32UTF8