RE: exporting

expdp userid/password
directory=DUMP_DIR
dumpfile=20160226_clmprd.dmp
SCHEMAS=roswellclm
Logfile=clmprd.log

I created the directory dump_dir as /u03/oradata/dumpdir I gave the userid read, write privs on the directory dump_dir

I checked at the OS level and the oracle user can read, write to those directories.

I guess the question is, where is the log file going? Does it go to the same directory?

Brian

From: Chris Stephens [mailto:cstephens16_at_gmail.com] Sent: Thursday, February 25, 2016 7:00 PM To: Zelli, Brian
Cc: oracle-l (oracle-l_at_freelists.org) Subject: Re: exporting

can you give the expdp command and directory ddl?

On Thu, Feb 25, 2016 at 5:46 PM, Zelli, Brian <Brian.Zelli_at_roswellpark.org<mailto:Brian.Zelli_at_roswellpark.org>> wrote: Getting this error:

ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39145: directory object parameter must be specified and non-null

I created the directory file and gave rights to the user to write there. What am I missing?

Brian

This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.

This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.

--
http://www.freelists.org/webpage/oracle-l