advertisements
_____________________________________________________________________________________________________________________
Error Description:
Oracle datapump impdp fails with following error.
impdp dumpfile=exp_TAB_28122011.dmp directory=DATA_PUMP_DIR logfile=exp_TAB_28122011_imp.log job_name=EXP ignore=y
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing 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 536
ORA-29283: invalid file operation
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing 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 536
ORA-29283: invalid file operation
Solution Description:
This error is because the impdp can not write the log file to the currsponding log file location. You can fix this error by checking the following things.
- Find out the curresponding DATA_PUMP_DIR from the dba_directories view and check whether the directory physically present in the file system
- Check whether enough permissions (READ & WRITE) are granted to the user who is performing the import. Suppose if you are performing the import using Scott user, you can use this command to give the permissions.
GRANT READ, WRITE ON DATA_PUMP_DIR TO SCOTT;
- OS level: Check the oracle user has the write, read access on the directory mentioned in the impdp. You can change the permission on OS level using chmod command.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment