I have one db dump below is the log file for that dump Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production Starting 'SYSTEM'.' SYS_EXPORT_SCHEMA_01': system/******** PARALLEL=1 SCHEMAS=tmsmv DUMPFILE=tmsmv-20120706.dmp LOGFILE=tmsmv-20120706.log Estimate in progress using BLOCKS method. Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 146.1 MB.. I want to restore this dump using another user tmsmv using below command: sql>conn / as sysdba CREATE OR REPLACE DIRECTORY DUMP_DIR AS '/home/./'; GRANT READ, WRITE ON DIRECTORY DUMP_DIR TO tmsmv; GRANT READ, WRITE ON DIRECTORY SYS.DUMP_DIR TO EXP_FULL_DATABASE; GRANT READ, WRITE ON DIRECTORY SYS.DUMP_DIR TO IMP_FULL_DATABASE; And then importing with: impdp tmsmv/***** schemas=TMSMV directory=DUMP_DIR dumpfile=tmsmv-20120706.dmp While restoring I am facing below error message: 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 Please help me to solve this issue. It looks like Oracle can't read the.dmp file, because it's under another user's home directory.

Oracle has to be able to read it, not the Linux user you're running the impdp command as. (Contrary to my earlier misleading comments!) Assuming the two users are in different groups, you may need to make the.dmp file world-readable: chmod o+r /home/./tmsmv-20120706.dmp And usually all directories in the path need to be world-readable and world-executable: chmod o+rx /home/./ If you wanted the log file to be created, it would be need to be writable too ( chmod o+rwx). If it's in a subdirectory of your home directory, you might need to do this to all intermediate levels. But relaxing permissions on your home directory can be a problem, so you might be better off using a directory somewhere else.

When I am trying to import.DMP file via SQL developer I am getting this error Exception: ORA-31640: unable to open dump file '/home/oracle/Desktop/dump/vahe.DMP' for. When I am trying to import.DMP file via SQL developer I am getting this error Exception: ORA-31640: unable to open dump file '/home/oracle/Desktop/dump/vahe.DMP' for.

Or leave the file where expdp put it, and grant permissions on that DIRECTORY object to tmsmv instead. Download Software Another Novel Yukito Ayatsuji Pdf.

Question: I am getting the ORA-31640 error during an import: impdp target_user/pwd@target_instance directory=DATA_PUMP_DIR dumpfile=source_user.dmp logfile=target_user.log remap_schema=source_user:target_user ORA-39000: bad dump file specification ORA-31640: unable to open dump file '/xxxxxxx/exp/xxx_xxxx_xxxx_01.dmp' for read ORA-27054: NFS file system where the file is created or resides is not mounted with correct options Additional information: 3 Answer: The shows this for the ORA-31640 error: ORA-31640 Unable to open dump file 'string' for read. Cause: Take appropriate action to restore the device.

Action: Import was unable to open the export file for reading. This message is usually followed by device messages from the operating system. Give full permission to the import directory from OS: $ chmod 777 /u01/export/dump Next, check the location of directory from view dba_directories and give full permission all directories mentioned in dba_directories: SQL>select * from dba_directories; The ORA-31640 error in RAC If running RAC, ensure that the mount was not being accessible from the second node in the cluster (check that the disk is accessible from all nodes in the RAC cluster) 1 - Unmount and Mount the NFS file system again.