expdp to multiple directories - Oracle Database Script.
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 directories TO pointing TO diff PATH SQL>
CREATE directory DIR1 AS '/home/oracle/DIR1';
Directory created. SQL>
CREATE directory DIR2 AS '/home/oracle/DIR2';
Directory created. parfile content dumpfile=DIR1:test_%U.dmp,
DIR2:test_%U.dmp LOGFILE=test.log directory=DIR1 PARALLEL=2 TABLES=raj.test