Dear all,

I wrote a script to take export backup of my oracle database..

{code}


ORACLE_SID=MATHS export ORACLE_SID
ORACLE_HOME=/rt/klal/oracle/product/111 export ORACLE_HOME
NLS_LANG=AMERICAN_AMERICA.AL32UTF8 export NLS_LANG
PATH=$PATH/usr/ccs/bin:/usr/bin:/usr/ucb:/etc:/usr/bin;
export PATH
DT=`date +"%Y%m%d%H%M%S"`
nohup $ORACLE_HOME/bin/exp system/manager@MATHS file=/rt/wrk/backup/exp_PROD_"$DT".dmp log=/rt/wrk/backup/exp_PROD_"$DT".log full=y grants=none statistics=none &

{code}

I want to compress the dmp file after backup.. is there anyway I can do this after the completion of the script ?..

or is there anyway .. I can write a script to take the uncompressed files or the last created files from the directory and compress it ?

Please advise


Kai

Ummm ... of course there is:

inside your script:

bzip2 $file

Btw... code-tags on LQ are [ code ] and [ /code ]
(without the spaces inside the square brackets),
not curly brackets.



Cheers,
Tink