Home » RDBMS Server » Server Utilities » Data Pump Error (Oracle 11g, Hp Unix)
Data Pump Error [message #442112] Thu, 04 February 2010 13:58 Go to next message
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 #442113 is a reply to message #442112] Thu, 04 February 2010 14:06 Go to previous messageGo to next message
Michel Cadot
Messages: 59751
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
granted read, write permissions for all the users on the unix folder.

And execute permission? And the directories above?

Regards
Michel
Re: Data Pump Error [message #442117 is a reply to message #442112] Thu, 04 February 2010 14:35 Go to previous messageGo to next message
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 #442119 is a reply to message #442117] Thu, 04 February 2010 14:41 Go to previous messageGo to next message
Michel Cadot
Messages: 59751
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ls -ld /work
ls -ld /work/ces
ls -ld /work/ces/datapump

Regards
Michel

Re: Data Pump Error [message #442121 is a reply to message #442117] Thu, 04 February 2010 14:55 Go to previous messageGo to next message
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 #442134 is a reply to message #442121] Thu, 04 February 2010 22:42 Go to previous messageGo to next message
Michel Cadot
Messages: 59751
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
s1dda35:11.1.0.7.0$ ls -ld /work/ces/datapump
drwxrwxrwx 2 oracle dba 96 Feb 4 15:42 /work/ces/

Something wrong in the output.

Regards
Michel
Re: Data Pump Error [message #442230 is a reply to message #442134] Fri, 05 February 2010 09:22 Go to previous messageGo to next message
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 #442231 is a reply to message #442230] Fri, 05 February 2010 10:03 Go to previous messageGo to next message
Michel Cadot
Messages: 59751
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback, we really appreciate it.

Regards
Michel
Re: Data Pump Error [message #468265 is a reply to message #442113] Thu, 29 July 2010 07:11 Go to previous messageGo to next message
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 Go to previous message
BlackSwan
Messages: 23034
Registered: January 2009
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/
Previous Topic: SQL-Loader: How to dynamically create multiple records out of one CSV input line?
Next Topic: How to export a user without data of few tables
Goto Forum:
  


Current Time: Sun Nov 23 18:38:34 CST 2014

Total time taken to generate the page: 0.08171 seconds