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!

Weird file access problem with impdp/expdp

207910Apr 23 2007 — edited Apr 23 2007
I've read the docs, I've searched Google and MetaLink. I'm stumped.

I'm trying to do an impdp or expdp and keep getting the "ORA-39070: Unable to open the log file." messages. All the docs says that this means your directory isn't valid.

Here's the details:

SQL> l
1* select * from dba_directories
SQL> /

DIRECTORY_NAME DIRECTORY_PATH
-------------------- ----------------------------------------
DATA_PUMP_DIR /u02/exports/PASDEV
-- Others omitted.

$ ls -ld /u02/exports/PASDEV /u02/exports /u02
drwxr-xr-x 7 oracle oinstall 8192 Aug 7 2006 /u02
drwxr-x--- 4 oracle oinstall 96 May 4 2006 /u02/exports
drwxrwxr-x 2 oracle oinstall 8192 Apr 23 10:48 /u02/exports/PASDEV

The permissions on the directory are good. It exists. I copied and pasted the directory path for the "ls" to avoid typos.

I'm doing the expdp/impdp as system, so permissions shouldn't be an issue and I'm logged on the box as "oracle".

Any ideas? Stumped!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 21 2007
Added on Apr 23 2007
4 comments
396 views