Oracle Database Discussions

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!

expdp setup

481897Apr 11 2007 — edited May 4 2007

Hello,

I have a 10.2.0 database. I am trying to setup a data pump export by using EXPDP. Here is my command and errors. It looks like the DIRECTORY setup is incorrect. How do i setup this?

Thanks a lot!

sky% expdp system/manager DIRECTORY=/export/db43/oradata DUMPFILE=exp.dmp tables=abc.t1

Export: Release 10.2.0.3.0 - 64bit Production on Wednesday, 11 April, 2007 10:11:15

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name /EXPORT/DB43/ORADATA is invalid

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2007

Added on Apr 11 2007

#general-database-discussions

29 comments

3,780 views