Dump an oracle database on multiple files (split)

$ expdp system/******** logfile=exp_pdco1mob00_full_12232013.txt directory=ABC dumpfile=exp_pdco1mob00_full_1_12232013.dmp,exp_pdco1mob00_full_2_12232013.dmp,exp_pdco1mob00_full_3_12232013.dmp,exp_pdco1mob00_full_4_12232013.dmp full=y exclude=statistics filesize=5g

Using compression

expdp test/test compression=all directory=dp dumpfile=wcomp.dmp

DUMPFILE=expdir:exp%U.dmp

FILESIZE=2G

This will create multiple dmp files. As one dmp files grows past the 2 gigabytes filesize, a second dmp file till be created, and so on, all multiple dmp files being stored in 2 gigabyte chunks.

Import exported database with multiple files

$IMPDP directory=ABC dumpfile=exp_pdco1mob00_full_1_12232013.dmp,
exp_pdco1mob00_full_2_12232013.dmp,
exp_pdco1mob00_full_3_12232013.dmp,
exp_pdco1mob00_full_4_12232013.dmp 
logfile=IMPORT_DUMP full=y

Script

#!/bin/bash

TODAY=`(set \`date\`; echo $2_$3)`

export LOG=/home/user/log
export ORACLE_HOME=/home/oracle/client/v11.2.0.3-64bit/client_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin

exp < username > /< password >@//< host > owner= < schema > file=exp_$TODAY.dmp  log=exp_$TODAY.log

exit;
EOF