Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

expdp error

Status
Not open for further replies.

Broad21

MIS
Joined
May 23, 2007
Messages
9
Location
US
:confused:
I granted myself read and write access for DATA_PUMP_DIR and also logged into super user. I then executed below statement to extract data from oraclr into a dump file

$ORACLE_HOME/bin/expdp claire/claire@orafin1 schemas=finance directory=DATA_PUMP_DIR dumpfile=claire_finance.dmp logfile=claire_finance.log

Here are the error messages.
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/proj/backups/db/orafin1/expdp/current/claire_finance.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3

Please advise and thanks in advance.
 
Can you verify the oracle user has full access to /proj/backups/db/orafin1/expdp/current
 
could you create files as orcle user on this directory ?
It looks like that this directory is not a local one, and if so the right miounting options are missing

 
If this is an NFS mount, there are a few things you can do:

1) set event 10298 in the database (from i think this requires bouncing the database )

2) get the sysadmin to adjust the rsize and wsize parameters for the NFS mount.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top