Problems setting up Dumpfile Location [message #294677] |
Fri, 18 January 2008 07:23 |
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
|
|
|
|
|