Script for tablspace full sends a email

[sagarbhat]

Dear all
i have seen this script

-- SQL script to get tablespace infomation
-- checkfree.sql

set heading off
set feedback off
set linesize 256
set tab off

col Name format a20
col "Data file" format a20


select
free.tablespace_name "Name",
df.file_name "Data file",
df.bytes "Size (bytes)",
TO_NUMBER(sum(free.bytes)) "Free (bytes)",
round(100*sum(free.blocks)/df.blocks) "(%)"
from dba_free_space free,
dba_data_files df
where free.file_id=df.file_id
group by free.tablespace_name,
df.file_name,
df.bytes,
df.blocks
order by 1;

/* Shell script to call */
/* $5 mean free percentage tablespace remain */

sqlplus system/manager @checkfree.sql | \
awk '$5 < 20 {print}' | mail -s "Tablespace near full" administrator@yourcompany.com


i just have to send the information of all the tablspace top the mention email ID how could i do it

or

the above script how could i do it ....i dont know the shell scripting so please help me to resolve this .......

[PAVB]

spool report out to a file and send it using sendmail

[sagarbhat]

hi all
please let me know how to use sendmail in oracle
as i will mail the output in sendmail

please help me

[PAVB]

log into your Unix box
man sendmail