<div>
Thanks for reply, I have few questions:<br />
1 create or replace directory data_pump_dir as 'h:\app\dell\admin\Raxa7\d<wbr />pdump';<br />
&nbsp; &nbsp;above command I can execute through SQLPLUS?<br />
2 and if you don't run that script with the exporting user, you need to supply grants too<br />
&nbsp; &nbsp; Did not understand properly<br />
3 create directory your_dir as 'h:\yourpath';<br />
&nbsp; &nbsp; above command I can create through SQL Plus?
</div>


<div>
those &quot;create or replace dir..&quot; are sql statements.<br />
sql*plus is for executing sql, so yes, they run with that (or sql developer, toad, ... )<br />
<br />
you need the required privileges to create an oracle database directory object<br />
<br />
if you have the privs to create a dir in the database,<br />
the statement always works, even if the directory does not physically exist on the oracle database host <br />
<br />
the exporting user needs read/write priviliges to work on the directory being used for export<br />
sample with userX and userY<br />

<pre><code class="code-1 nolinks" id="code-20-42565778-1"><span>connect userX/pw </span>
<span>create directory test_dir as 'c:\temp';</span>
<span></span>
<span>expdp userY/pw directory=test_dir schemas=test dumpfile=test.dmp</span>
<span>&gt; this will fail</span>
</code></pre>
<br />
solution: <br />

<pre><code class="code-1 nolinks" id="code-20-42565778-2"><span>connect userX/pw</span>
<span>grant read,write on directory test_dir to userY;</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
Hi I am using 11G database, Right now for creating Dump file I have to go to Database bin folder(H:\app\Dell\product<wbr />\11.2.0\db<wbr />home_1\BIN<wbr />) &nbsp;and through command prompt I have to go to that path then i am able to create expdp command &nbsp;but it generated dump file on different location((H:\app\Dell\admi<wbr />n\Raxa7\dp<wbr />dump) ) what I want is without going to go into Bin folder I should be able to execute expdp command and create dump on same path from any location. Please help how I can do that. FYI I have installed 2 database in my machine.
</div>
</div>


Hi I am using 11G database, Right now for creating Dump file I have to go to Database bin folder(H:\app\Dell\product\11.2.0\dbhome_1\BIN)  and through command prompt I have to go to that path then i am able to create expdp command  but it generated dump file on different location((H:\app\Dell\admin\Raxa7\dpdump) ) what I want is without going to go into Bin folder I should be able to execute expdp command and create dump on same path from any location. Please help how I can do that. FYI I have installed 2 database in my machine.

Setting Path of Oracle so Dump file can be created on any location

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.