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 strongm 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
May 23, 2007
9
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