Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-39145 during expdmp when DIRECTORY option not specified.

701636Jul 7 2009 — edited Aug 26 2009
expdp dumpfile=<dirname>:<dumpname.dmp>


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

Command run is :
$ expdp tables=regions DUMPFILE=table.dmp


Is the option DIRECTORY compulsory ?

As per the Oracle 10gR2 Utilities guide it states :
Users with access to DATA_PUMP_DIR need not use the DIRECTORY parameter at all.


I have already given the user HR access of read,write to the directory DATA_PUMP_DIR.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2009
Added on Jul 7 2009
#database-key-features, #export-import-sql-loader-external-tables
7 comments
16,655 views