Actually I’m upgrading a database (Release 9.2.5.0) to 12c, It is a small database because of this I prefer perform a (traditional) exp and imp that upgrade to a 10g and after that upgrade to 12c.
The problem I have found is when generate the dmp file, the file system have 20 gigas of free space and the dmp file size is greater. There are some solutions, in my case I selected compress the dmp file while it is generated using a unix pipe. Here I show the script;
orange-3@> cat dumper.sh
#!/bin/ksh
export ORACLE_SID=FINAN
export ORACLE_HOME=/oracle/server/925
DIRECTORY=/dummy; export DIRECTORY
FILENAME=${DIRECTORY}/fichero_grande.dmp.gz; export FILENAME
LOG=${DIRECTORY}/fichero_grande.log; export LOG
PIPE=${DIRECTORY}/export_pipe.dmp; export PIPE
test -p ${PIPE} || mknod ${PIPE} p
chmod +rw ${PIPE}
cat $PIPE | /usr/bin/gzip > ${FILENAME} &
${ORACLE_HOME}/bin/exp log=${LOG} buffer=104857600 file=${PIPE} owner=FINANCIAL << EOF
financial/xxxxxxxxxx
EOF
HTH – Antonio NAVARRO
Advertisements
