![]() ![]() If it's in a subdirectory of your home directory, you might need to do this to all intermediate levels. (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). Oracle has to be able to read it, not the Linux user you're running the impdp command as. It looks like Oracle can't read the.dmp file, because it's under another user's home directory. 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. 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. ![]() Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 146.1 MB. 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. Probably impdp program execs as 'oracle' and not as 'aleph' user. ORA-31617: unable to open dump file “/dumparea/TEST/asset_75.dmp” for write. PROBLEM: While taking expdp in rac database, got below error. ĭrwxrwxrwx 3 oracle dba 256 Jan 05 12:59. Or, You can see all the privileges for all directories with the following script : select *fromĭirectory privileges: READ and WRITE. ORA-31640: unable to open dump file "C:\app\admin/admin/orcluat/dpdump/expfULLDB.DMP" for read With the Partitioning, OLAP, Data Mining and Real Application Testing options All rights reserved.Ĭonnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production I was trying to import dump file to my test oracle database using the following import line: Import: Release 11.2.0.4.0 - Production on Wed jan 10 10:52:34 2018Ĭopyright (c) 1982, 2011, Oracle and/or its affiliates. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |