| Data Pump Error [message #442112] |
Thu, 04 February 2010 13:58  |
kkumar205
Messages: 4
Registered: February 2010
|
Junior Member |
|
|
Hello:
I am using Oracle 11g data pump to export with remap_data option, I have created the export directory and granted read write permissions and also granted read, write permissions for all the users on the unix folder.
I am still getting the ORA-39002: invalid operation and ORA-39070: Unable to open the log file errors.
Not sure what is missing. Thanks in advance.
Export Directory created:
create or replace directory expdp as '/work/ces/datapump';
GRANT READ,WRITE ON directory expdir TO system;
Export Command used
expdp system dumpfile=export.dmp logfile=export_logfile.log
tables=CES.DATA_IN directory=expdir
remap_data=CES.DATA_IN.SNS:schema.datapump_masking.random_sns
Export: Release 11.1.0.7.0 - 64bit Production on Thursday, 04 February, 2010 14:02:26
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
|
|
|
|
|
|
| Re: Data Pump Error [message #442117 is a reply to message #442112] |
Thu, 04 February 2010 14:35  |
kkumar205
Messages: 4
Registered: February 2010
|
Junior Member |
|
|
/work folder is owned by root all the folders (ces/datapump) under that was granted with read,write and execute to all the users.
chmod 777
Thanks
|
|
|
|
|
|
| Re: Data Pump Error [message #442121 is a reply to message #442117] |
Thu, 04 February 2010 14:55 |
kkumar205
Messages: 4
Registered: February 2010
|
Junior Member |
|
|
host:11.1.0.7.0$ ls -ld /work
drwxr-xr-x 8 root root 8192 Sep 29 06:32 /work
s1dda35:11.1.0.7.0$ ls -ld /work/ces
drwxrwxrwx 49 oracle dba 8192 Feb 4 15:06 /work/ces
s1dda35:11.1.0.7.0$ ls -ld /work/ces/datapump
drwxrwxrwx 2 oracle dba 96 Feb 4 15:42 /work/ces/
|
|
|
|
|
|
| Re: Data Pump Error [message #442230 is a reply to message #442134] |
Fri, 05 February 2010 09:22 |
kkumar205
Messages: 4
Registered: February 2010
|
Junior Member |
|
|
The error was due to the newline character after the first line in the expdp command due to this remaining part of the expdp command is not getting executed. And it didn't get the diretory details.
Thanks a lot and I really appreciate everybody's response and time.
|
|
|
|
|
|
| Re: Data Pump Error [message #468265 is a reply to message #442113] |
Thu, 29 July 2010 07:11 |
gbnora
Messages: 1
Registered: July 2010
|
Junior Member |
|
|
Why to the Unix permissions need to be so open?
I have found that 777 directory permissions are required but I would prefer not to be so open.
Even 770 directory permissions with the directory owner = to the oracle process owner fails.
What is going on?
|
|
|
|
| Re: Data Pump Error [message #468276 is a reply to message #468265] |
Thu, 29 July 2010 08:39 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
I don't know what you have.
I don't know what you do.
I don't know what you see.
It is really, really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
