Home » RDBMS Server » Server Utilities » EXPDP errors (Oracle 10.2 / Linux AS)
EXPDP errors [message #426216] Wed, 14 October 2009 07:31 Go to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Hi
while using datapump I am getting this error, any advise..?

sql> connect user33/pwd33@orcl
sql> create directory=EXPDP_TEST as '/dbusr1/dtdwtrd/input';
Directory created
sql>grant read,write on directory EXPDP_TEST to scott;
Grant succeeded.

sql> connect scott/tiger@orcl
sql> select * from dba_directories;
ERROR at line 1: tableor view does not exist

sql> select * from all_directories;
owner Directory_name Directory_path
sys EXPDP_TEST /dbusr1/dtdwtrd/input

Form Linux os prompt
[input]$ expdp scott/tiger@orcl tables=trd_acct directory=EXPDP_TEST

Export: Release 10.2.0.1.0 - 64bit Production on Wednesday, 14 October, 2009 7:18:58

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/dbusr1/dtdwtrd/input/expdat.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3

[input]$ cd ..
[dtdwtrd]$ pwd
/dbusr1/dtdwtrd

[dtdwtrd]$ ls -l
drwxrwxrwx 3 root root 8192 Oct 14 07:19 input
-- so that folder '/input' has write privilege

Note
I am able to use exp/imp from this os path & schema working fine

Thanks in advance
sbmk
Re: EXPDP errors [message #426224 is a reply to message #426216] Wed, 14 October 2009 07:59 Go to previous messageGo to next message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
 *Cause:  The file was on an NFS partition and either reading the mount tab
          file failed or the partition wass not mounted with the correct
          mount option.
 *Action: Make sure mount tab file has read access for Oracle user and
          the NFS partition where the file resides is mounted correctly.
          For the list of mount options to use refer to your platform
          specific documentation.

When you use exp, YOU create the file.
When you use expdp, Oracle creates the file.

Regards
Michel
Re: EXPDP errors [message #426236 is a reply to message #426216] Wed, 14 October 2009 09:23 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Hi Michel,

I am a off-shore Oracle dba/developer, I couldn't understand these os terminology, can u please explain more on these (or) book link. So that I can ask my 'Onsite Linux administrator' to do necessary changes.

How to check
1) mount tab file has read access ?
2) file is mounted correctly ?

Please refer my old post (your replay)
http://www.orafaq.com/forum/m/420568/103817/#msg_420568
"[Quote:
Note: Due to some os level restriction I can not use expdp/impdp.
Which ones?
Regards
Michel]"


Thanks in advance
sbmk





[Updated on: Wed, 14 October 2009 09:27]

Report message to a moderator

Re: EXPDP errors [message #426248 is a reply to message #426236] Wed, 14 October 2009 10:08 Go to previous message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask your sysadmin.

Regards
Michel
Previous Topic: SQL Loader
Next Topic: how to expdp to find out the table size/row without the data
Goto Forum:
  


Current Time: Mon Sep 26 00:55:14 CDT 2016

Total time taken to generate the page: 0.24082 seconds