Home » RDBMS Server » Server Utilities » Problems setting up Dumpfile Location (10g on win 2003 server)
Problems setting up Dumpfile Location [message #294677] Fri, 18 January 2008 07:23 Go to next message
Larry Cumber
Messages: 3
Registered: January 2008
Location: Birmingham
Junior Member
i am having problems setting up dumplocation.
I have created the directory using
SQL>Create Directory dumplocation As '/oradata/dumpfiles';
Directory created
>>> i have also granted READ,WRITE ON THIS DUMPLOCATION to the user
who is John
SQL>Grant read,write on directory dumplocation to John;

I do not want to create a default directory, which i would have done simply by
SQL>Create directory DATA_PUMP_DIR AS '/oradata/defaultdatadumps';

>>>PROBLEM<<<

on running my datapump exp is does not seem to locate the dumplocation.
>>expdp John/**** directory=dumplocation

Has anyone had this problem before? If so then give suggestions. Thanks
Re: Problems setting up Dumpfile Location [message #294921 is a reply to message #294677] Sun, 20 January 2008 21:36 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

What is your problem??
DATA_PUMP_DIR is the default location.
When you specify dumplocation as a directory there must exist it's location physically on drive as '/oradata/dumpfiles';
Re: Problems setting up Dumpfile Location [message #297418 is a reply to message #294921] Thu, 31 January 2008 07:08 Go to previous message
Larry Cumber
Messages: 3
Registered: January 2008
Location: Birmingham
Junior Member
i would therefore create a physical location and see if that works.
Previous Topic: exporting table in a different tablespace
Next Topic: is there any utility in oracle
Goto Forum:
  


Current Time: Sun Dec 04 04:27:26 CST 2016

Total time taken to generate the page: 0.10508 seconds