Dear sir,
I'm running with Oracle 8.1.6 on RH Linux 6.2EE. My daily export dump files are very huge and my disk space fallen alarmingly low. I want to do a compressed export using gzip and split, as Linux 6.2 has a limitation in size of 2G per file. If Any one out here had already implemented the same, can you please post the script, here . Actually I wrote a small script but it is throwing errors:
ERROR:
split: /u09/mytools/expimp/expdmp.gz_: No such file or directory
LRM-00118: syntax error at '=' at the end of input
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
Here is my Script:
====================
# -- export_dl.sh:
ORACLE_HOME=/opt/oracle/product/8.1.6
ORACLE_SID=cmsrpt1
OUTPUT_FILE=/u09/mytools/expimp/expdmp.gz_
export ORACLE_HOME ORACLE_SID OUTPUT_FILE
#
# Creation of a pipe for output of export
rm -f /u09/mytools/expimp/p
mkfifo -m 777 /u09/mytools/expimp/p
# Start export
#
cat p|gzip |split -b 1000m ${OUTPUT_FILE} &
#created an external user OPS$ORACLE inorder to protect
#user ids and passwords.
It would be a great help for me if any one can correct this script or send me their script which is implemented successfully. Because i need to productionalise this script by today evening.
Bookmarks