Differences

This shows you the differences between two versions of the page.

--- database:oracle:oracle_data_pump [2023/11/14 19:16]
manu created
+++ database:oracle:oracle_data_pump [2023/11/16 14:36] (current)
manu
@@ Line 1: / Line 1: @@
 ====== Oracle export/import database ======
-Import exported database with multiple files
+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>

wiki

User Tools

Site Tools

Differences

Page Tools