Home » RDBMS Server » Server Utilities » EXPDP getting error ORA-39002 (Export: Release 10.1.0.3.0 - 64bit Production on Friday, 20 June, 2014 13:34)
EXPDP getting error ORA-39002 [message #616804] Fri, 20 June 2014 13:57 Go to next message
iufaninark
Messages: 4
Registered: June 2014
Location: Little Rock
Junior Member
Hello ALL,

Looking for help getting started with expdp. Running on a Solaris box with Oracle 10g. I have created the directory object in Oracle and granted READ/Write to that object. I created the same directory under the OS. Then I run the following with these results:

expdp username@databasename PARFILE=dump.par

Export: Release 10.1.0.3.0 - 64bit Production on Friday, 20 June, 2014 13:34

Copyright (c) 2003, Oracle. All rights reserved.
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production
With the Partitioning and Data Mining 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 475
ORA-29283: invalid file operation

Here is what my PARFILE contains:
TABLES=user.t1,user.t2
VERSION=10.1
DIRECTORY=dumpdp
LOGFILE=dpumpt1.log
DUMPFILE=dpumpt1.dmp
CONTENT=DATA_ONLY

Re: EXPDP getting error ORA-39002 [message #616805 is a reply to message #616804] Fri, 20 June 2014 14:01 Go to previous messageGo to next message
BlackSwan
Messages: 23150
Registered: January 2009
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

my first guess would be that the current OS user does not have OS write permission on the current OS directory

issue following OS commands

id
ls -ld ./

COPY the results from above then PASTE all back here
Re: EXPDP getting error ORA-39002 [message #616806 is a reply to message #616805] Fri, 20 June 2014 14:18 Go to previous messageGo to next message
iufaninark
Messages: 4
Registered: June 2014
Location: Little Rock
Junior Member
[host]: id
uid=1438(conv) gid=330(dsaqsep)
[host]: ls -ld ./
drwxrwxrw- 2 conv dsaqse 512 Jun 20 14:12 ./
[host]:
Re: EXPDP getting error ORA-39002 [message #616815 is a reply to message #616806] Fri, 20 June 2014 14:49 Go to previous messageGo to next message
BlackSwan
Messages: 23150
Registered: January 2009
Senior Member
usually expdb is run against local database and no "@databasename" is specified.

Are you purposefully trying to export from some remote database?

what results from following OS command

pwd


BTW V10.1 is obsoleted, unsupported & VERY buggy. IMO, it should be avoided at all costs.
Re: EXPDP getting error ORA-39002 [message #616817 is a reply to message #616815] Fri, 20 June 2014 14:56 Go to previous messageGo to next message
iufaninark
Messages: 4
Registered: June 2014
Location: Little Rock
Junior Member
I am not exporting against a remote database. The database is on the same server as the expdp executable, but there are multiple databases on that same server, so I am telling the expdp command which database to log into.

The results of the pwd command:
I am sitting in the directory referenced by the Oracle directory object....
Re: EXPDP getting error ORA-39002 [message #616818 is a reply to message #616817] Fri, 20 June 2014 15:02 Go to previous messageGo to next message
BlackSwan
Messages: 23150
Registered: January 2009
Senior Member
>The results of the pwd command:
>I am sitting in the directory referenced by the Oracle directory object....

do NOT tell us what you think you see.
SHOW US!

>The database is on the same server as the expdp executable
then do similar to below

export ORACLE_SID=EXPDP_DB

& do not include "@databasename" on the command line.

I still believe the lack of OS permission is what results in the UTL_FILE error
Re: EXPDP getting error ORA-39002 [message #616823 is a reply to message #616818] Fri, 20 June 2014 16:08 Go to previous message
iufaninark
Messages: 4
Registered: June 2014
Location: Little Rock
Junior Member
You must be right in that it is an OS permission error. It appears that expdp is actually using the owner (OS owner) of that utility to write out the files (dump and log files). I tried the same command (but created another Oracle Directory object pointing to a directory that OS owner of the expdp utility also owned. I put my parfile (still owned by me) in that directory and it worked.

So the id issuing the expdp command does not need write access to the directory but the owner of the Oracle utility (Oracle itself) does.
Previous Topic: SQL Loader to fail in Warning and send email notifications
Next Topic: EXPDP hangs
Goto Forum:
  


Current Time: Fri Dec 19 21:27:36 CST 2014

Total time taken to generate the page: 0.12164 seconds