====== Oracle export/import database ======

Dump an oracle database on multiple files (split)
<cli prompt='$'>
$ 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
</cli>

Using compression
<cli prompt='$'>
expdp test/test compression=all directory=dp dumpfile=wcomp.dmp
</cli>

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
<cli prompt='$'>
$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


</cli>

Script 
<code>
#!/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
</code>