Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Pump Import File Permission

552527Jan 22 2007 — edited Jan 22 2007
I am trying to do a data pump import on a Sun OS box. I have a dumpfile that is no longer owned by the Oracle user, or the group the oracle user belongs to. What file permissions are needed on ths dumpfile for data pump import to work. Here is the error I received:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/cdwprd/cdwdp/dat/medstg_exp_ddl_200701221435.dmp" for read
ORA-17503: ksfdopn:3 Failed to open file /cdwprd/cdwdp/dat/medstg_exp_ddl_200701221435.dmp
ORA-17500: ODM err:ODM ERROR V-41-4-0-0-6 No such device or address

The file has read permissions for everything:

ls -l /cdwprd/cdwdp/dat/test.dmp
-rw-r--r-- 1 rhaberko cdwprd 172032 Jan 22 14:35 /cdwprd/cdwdp/dat/test.dmp

What more does it need to work properly? The database directory object is pointing to the correct directory. The db user has been granted read, write to this directory object.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2007
Added on Jan 22 2007
3 comments
787 views