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.


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:


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)