Weird file access problem with impdp/expdp
207910Apr 23 2007 — edited Apr 23 2007I'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!