-
Compressed Export file
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.
/opt/oracle/product/8.1.6/bin/exp / FILE=$p \
PARFILE=/u09/mytools/expimp/testexportparam_dl
# End export
exit
--testexportparam_dl:
# -- exportparam_dl :
LOG=/u09/mytools/logs/testexport_dl.log
CONSISTENT=Y
COMPRESS=N
#OWNER=dloader
TABLES=(d_claim,d_fintx)
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.
Many Thanks in advance
PNRDBA
-
Export through a named pipe.
http://www.experts-exchange.com/CXO/..._20569914.html
Just keep in mind you'll need to import via the pipe as well.
Last edited by KenEwald; 06-17-2003 at 03:45 PM.
-
Thanks for your kind help Ken. I'll go thru that site and try to implement it.
PNRDBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|