Suppose you wish to take a expdp backup of a big table, but you don’t sufficient space in a single mount point to keep the dump. In this case we take expdp dump to multiple directory.

DEMO:

Create 2 directories:

 

Now take export with parallel option:

 

 

Now you can see the dump file has been created in multiple directories.

 

Dump file set for RAJ.SYS_EXPORT_TABLE_01 is:
/home/oracle/DIR1/test_01.dmp
/home/oracle/DIR2/test_01.dmp

 

If you wish to compress the size , then you can use compression=all in the expdp command.

 

For import also you can use the similar method.

 

 

FYI- To use compression parameter in expdp , we need additional Advanced compression license,( Which is not included in enterprise edition)