Sunday, 30 December 2012

Oracle Expdp error ORA-39070,ORA-39002,ORA-29283,ORA-06512,ORA-29283


Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation


Solution : You have to manually create directory  and give writes to specified users on specified path then after you try your operation.


SQL> create directory expbkp as '/opt/oracle/expbkp';

SQL> grant read, write on directory expbkp to <user_name>;

SQL>select * from dba_directories where directory_name = 'EXPBKP';

Otherwise you can use DATA_PUMP_DIR which is defalut in Oracle 10g and Oracle 11g.

2 comments:

  1. ORA-39002: invalid operation
    ORA-39070: Unable to open the log file.
    ORA-29283: invalid file operation
    ORA-06512: at "SYS.UTL_FILE", line 475
    ORA-29283: invalid file operation


    plz help me to solve the problem

    ReplyDelete
    Replies
    1. Yawar .. Please share the command and output from select * from dba_directories . Meanwhile you can follow above steps as errors are same .

      Delete