Sometimes we may need to take export to multiple Filesystem as one Filesystem donot have that much space on our server

In such point we can use the multiple directories feature of EXPDP utility. Using this feature we can create dumpfile in multiple directories and distribute our logical export job to different directories on server side.

Let us check how we achive this.

• Create new 2 directories or add new one to existing directories. Consider two directories named DIRECTORY1 and DIRECTORY2 in Oracle Database :-

SQL > create or replace directory DIRECTORY1 as ‘/export_disk/DIRECTORY1’;

Directory created.

SQL > create or replace directory DIRECTORY2 as ‘/export_disk/DIRECTORY2’;

Directory created.

• Check directories
  SQL > select * from dba_directories;

OWNER DIRECTORY_NAME DIRECTORY_PATH

SYS DIRECTORY2 /export_disk/DIRECTORY2
SYS DIRECTORY1 /export_disk/DIRECTORY1

• Now start export to multiple directories.

$ expdp “‘/ as sysdba’” dumpfile=DIRECTORY1:expdp_DIRECTORY1_%U.dmp,DIRECTORY2:expdp_DIRECTORY2_%U.dmp compression=all parallel=6

Important part –> Parallel parameter must be used while using multiple directories, otherwise expdp will not fail but it will write to only first directory. Number of directories used must be equal to parallel parameter then only all directories will be used for writing.