EXPDP and IMPDP Directory

Hi,

As we know with oracle 10g we export datapump utility ofr taking the export and impdp for import.Now expdp as well as impdp requires directory to be created so that all the exports taken are stores in that directory and all the import dumps which are read by impdp will read from that directory.

So, before using expdp and impdp we need to create directory ,so this post is mainly meant for creation of directory

First we need to create a directory at the OS level using OS commands at a suitable path where you want your export dump to be stored .

So, after the creation of directory at the os level enter in the sqlplus as system

sqlplus system/manager

WINDOWS

SQL> create or replace directory my_dir as ‘D:\my_dir’;

SQL> grant read,write on DIRECTORY my_dir to public;

UNIX

SQL> create or replace directory my_dir as ‘/oracle/backup/export’

SQL> grant read,write on DIRECTORY my_dir to public;

Thus now u can use this directory while taking your export using expdp or while taking import using impdp

the syntax for expdp is as shown:

# expdp system/manager directory=my_dir dumpfile=exp_tab.dmp logfile=exp_tab.log full=y;

Similarly

# impdp  system/manager directory=my_dir dumpfile=exp_tab.dmp logfile=imp_tab.log full=y;

Also if you can have any other directory created where  can keep your logfiles.The Method to create the directory is similar as mentoned above and u can specify that your logfiles should be placed in that directory by using following syntax

#expdp system/manager directory=my_dir dumpfile=exp_tab.dmp logfile=log_dir:exp_tab.log  full=y;

Thanks and Regards

Parikshit