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
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