Re: Send Mail in Unix
Hi! This should work: $ sendmail -v [EMAIL PROTECTED] your_report_file.xls -v means: verbose you can skip it! HTH JL --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: All, I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun Unix box to myself when the batch job runs. Anybody been able to do this? I can send the text of the file, but what I really want to do is to send the file (it's an Excel Spreadsheet). thanks in advance. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Send Mail in Unix
UUENCODE the file then send it as text.UUDECODE it back to a file at the recipient. -Original Message- Sent: Thursday, February 13, 2003 9:44 AM To: Multiple recipients of list ORACLE-L All, I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun Unix box to myself when the batch job runs. Anybody been able to do this? I can send the text of the file, but what I really want to do is to send the file (it's an Excel Spreadsheet). thanks in advance. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Send Mail in Unix
Hi I have a function called mail_dba which i load in my .profile
In .profile
FPATH=$ORACLE_BASE/admin/$ORACLE_SID/dbafuncs
export FPATH
autoload mail_dba
Then in the location specified by FPATH i have a file called mail_dba
which contains the following:
mail_dba_ ()
{
mailx [EMAIL PROTECTED] EOF
~s$1
~r$2
EOF
}
This says that the first parameter i pass is the subject, and the
second is a file to mail.
Then i invoke it like this:
mail_dba Email Subjest name_of_file_to_send
Hope this helps.
Cheers
Ceri
Thanks
Ceri
--
CeriDatabase Administrator
mailto:[EMAIL PROTECTED] ICQ:153010767
I love deadlines. I like the whooshing sound they make as they fly by.
Douglas Adams
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ceri Townsend
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Send Mail in Unix
You mean: mailx -m -s Test Message [EMAIL PROTECTED] EOF `ux2dos /home/report/tbsp.lst | uuencode /home/report/tbsp.lst` This is from an HP-UX system hth mohammed --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: All, I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun Unix box to myself when the batch job runs. Anybody been able to do this? I can send the text of the file, but what I really want to do is to send the file (it's an Excel Spreadsheet). thanks in advance. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mkb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Send Mail in Unix
Thomas, Thursday, February 13, 2003, 9:44:07 AM, you wrote: M All, M I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun M Unix box to myself when the batch job runs. M Anybody been able to do this? I can send the text of the file, but what I M really want to do is to send the file (it's an Excel Spreadsheet). The trick is to uuencode it. Here's a snippet from a shell script I use to convert an HTML document with images to a .pdf and mail it to myself: echo Latency graphs for `date` /tmp/mailphcsc.$$ echo /tmp/mailphcsc.$$ htmldoc --webpage -f /tmp/latencyphcsc.pdf latencyphcsc.html uuencode /tmp/latencyphcsc.pdf latencyphcsc.pdf /tmp/mailphcsc.$$ cat /tmp/mailphcsc.$$ | mailx -s Latency Graphs [EMAIL PROTECTED] I'm using a tmp file since I'm adding text around the attachment. It can probably be done with just a: cat spreadsheet.xls | uuencode spreadsheet.xls | mail \ [EMAIL PROTECTED] -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Send Mail in Unix
Tom, Look at the 'uuencode' utility - it can do what you want. Care to share how you generated an Excel Spreadsheet in Solaris? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 I don't know what the future holds for me, but I do know who holds my future! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 7:44 AM To: Multiple recipients of list ORACLE-L Subject: Send Mail in Unix All, I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun Unix box to myself when the batch job runs. Anybody been able to do this? I can send the text of the file, but what I really want to do is to send the file (it's an Excel Spreadsheet). thanks in advance. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Send Mail in Unix
try 'uuencode server filename to whateverfilename | mail [EMAIL PROTECTED]' Thanks Ana E. Choto Systems Programmer American University e-Operations - Information Technology Phone (202) 885-2275 Fax (202) 885-2224 Mercadante, Thomas F [EMAIL PROTECTED] To te.ny.us Multiple recipients of list Sent by: ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc Subject 02/13/2003 10:44 Send Mail in Unix AM Please respond to ORACLE-L@fatcity. com All, I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun Unix box to myself when the batch job runs. Anybody been able to do this? I can send the text of the file, but what I really want to do is to send the file (it's an Excel Spreadsheet). thanks in advance. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ana Choto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Send Mail in Unix
Mohammed, thanks, but the -m option does not seem to exist in Sun Unix. $ mailx -m mailx: illegal option -- m Usage: mailx -eiIUdFntBNHvV~ -T FILE -u USER -h hops -r address -s SUBJECT -f FILE users any other ideas? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, February 13, 2003 12:42 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] You mean: mailx -m -s Test Message [EMAIL PROTECTED] EOF `ux2dos /home/report/tbsp.lst | uuencode /home/report/tbsp.lst` This is from an HP-UX system hth mohammed --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: All, I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun Unix box to myself when the batch job runs. Anybody been able to do this? I can send the text of the file, but what I really want to do is to send the file (it's an Excel Spreadsheet). thanks in advance. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Send Mail in Unix
I use mutt which has the option to attach a file. mutt -s 'subject' -a filename user@mailserver /dev/null would send an attachment with no body, put a file instead of /dev/null if you want a body for the message. With mailx in unix, I've been told it can be done by piping through uuencode or something, but I haven't done that. I'm also sure it can be done with perl, some of the perl guru's on the list might be able to provide details. -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Subject: Send Mail in Unix All, I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun Unix box to myself when the batch job runs. Anybody been able to do this? I can send the text of the file, but what I really want to do is to send the file (it's an Excel Spreadsheet). thanks in advance. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Send Mail in Unix
All, I guess I made the mistake mentioning Excel. I am creating a tab delimited text file with an .xls file type that Excel can easily open. It is not a binary Excel file. I just need to be able to send the file as an attachement. thanks again and sorry for the mis-statement! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, February 13, 2003 12:45 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] There are a couple of ways to do it. You could uuencode it and then mail the encoded file. The file has to be decoded on the other end. I send binaries off the server to users who wouldn't be familiar with decode software using a python program that builds a mime message with the file attached to the message. You can do the same with perl. Glenn Stauffer - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 10:44 AM All, I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun Unix box to myself when the batch job runs. Anybody been able to do this? I can send the text of the file, but what I really want to do is to send the file (it's an Excel Spreadsheet). thanks in advance. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Send Mail in Unix
Tom,
Here is a perl script that will send the file as an attachment.
HTH
Peter
#!/usr/bin/perl -w
# mail_attach.pl -- Mail files as attachments
# Created new perl script mostly from MLB 11/09/1999
# The Perl Journal 14 mail_attach.pl example
#
# $ARGV[0]: The sender e-mail address
# $ARGV[1]: Filename with main message in it.
# $ARGV[2]: Filename to attach.
# If 1, separate with commas and *no* spaces
# $ARGV[3]: Subject
# $ARGV[4..$#ARGV]: Destination e-mail addresses.
# If there are spaces in
# an address, then enclose it in quotes
# use strict;
# use Socket;
use MIME::Lite;
use Net::SMTP;
my %ending_map = (
crt = ['application/x-x509-ca-cert' , 'base64'],
aiff = ['audio/x-aiff' , 'base64'],
gif = ['image/GIF' , 'base64'],
txt = ['text/plain' , '8bit'],
com = ['text/plain' , '8bit'],
class= ['application/octet-stream' , 'base64'],
htm = ['text/html' , '8bit'],
html = ['text/html' , '8bit'],
htmlx= ['text/html' , '8bit'],
htx = ['text/html' , '8bit'],
jpg = ['image/jpeg' , 'base64'],
dat = ['text/plain' , '8bit'],
hlp = ['text/plain' , '8bit'],
ps = ['application/postscript' , '8bit'],
'ps-z'= ['application/postscript' , 'base64'],
dvi = ['application/x-dvi' , 'base64'],
pdf = ['application/pdf' , 'base64'],
mcd = ['application/mathcad' , 'base64'],
mpeg = ['video/mpeg' , 'base64'],
mov = ['video/quicktime' , 'base64'],
exe = ['application/octet-stream' , 'base64'],
zip = ['application/zip' , 'base64'],
bck = ['application/VMSBACKUP' , 'base64'],
au = ['audio/basic' , 'base64'],
mid = ['audio/midi' , 'base64'],
midi = ['audio/midi' , 'base64'],
bleep= ['application/bleeper' , '8bit'],
wav = ['audio/x-wav' , 'base64'],
xbm = ['image/x-xbm' , '7bit'],
tar = ['application/tar' , 'base64'],
imagemap = ['application/imagemap' , '8bit'],
sit = ['application/x-stuffit' , 'base64'],
bin = ['application/x-macbase64'],
hqx = ['application/mac-binhex40' , 'base64'],
);
my $mail_from= shift @ARGV;
my $message_file = shift @ARGV;
my @mail_file= split(,, shift(@ARGV));
my $subject = shift @ARGV;
my @mail_to = @ARGV;
my $logname = getpwuid($);
my $logdate = `date`;
open(LOG,/tech/cc/banner/mail_attach.log);
print LOG \n;
print LOG Date = ,$logdate;
print LOG Laurel Username = ,$logname,\n;
print LOGMail From = ,$mail_from,\n;
print LOG Message file = ,$message_file,\n;
print LOG Attached File(s) = ,@mail_file,\n;
print LOG Subject = ,$subject,\n;
print LOG Mail To = ,@mail_to,\n;
print LOG \n;
close(LOG);
my $mime; # The MIME object
# Slurp in the message text and build up the main
# part of the mail.
{
local $/;
$/ = undef;
local @ARGV;
@ARGV = $message_file;
my $main_message = ;
$mime = new MIME::Lite( From= $mail_from,
To = [@mail_to],
Subject = $subject,
Type= 'text/plain',
Data= $main_message);
}
foreach (@mail_file) { # Attach each file in turn
my($type, $ending);
/.*\.(.+)$/; # Snag the ending
$ending = $1;
# Is it in our list?
if (exists($ending_map{$ending})) {
$type = $ending_map{$ending};
} else {
$type = ['text/plain', '8bit'];
}
# Attach it to the message
$mime-attach( Type = $type-[0],
Encoding = $type-[1],
Disposition = attachment,
Path = $_);
}
# Tell MIME::Lite to use Net::SMTP instead of sendmail.
MIME::Lite-send('smtp', 'axe', Timeout = 20);
$mime-send;
At 07:44 AM 02/13/2003 -0800, you wrote:
All,
I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun
Unix box to myself when the batch job runs.
Anybody been able to do this? I can send the text of the
RE: Send Mail in Unix - solved!
OMG!!! Thanks to all! It actually works! This is what works for me: I run a sql script that produces a tab delimited report showing tablespace usage (think of the OEM screen showing all the tablespaces with size, used and free listed). I then use the following command to send the report to me: uuencode filename outfile.xls | mailx -s Dslb1osa Rpt_Tablespaces tom@email_addr Even though the file is a text file, it still comes along as an attachment! really cool! thanks everyone! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, February 13, 2003 12:45 PM To: Multiple recipients of list ORACLE-L Mohammed, thanks, but the -m option does not seem to exist in Sun Unix. $ mailx -m mailx: illegal option -- m Usage: mailx -eiIUdFntBNHvV~ -T FILE -u USER -h hops -r address -s SUBJECT -f FILE users any other ideas? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, February 13, 2003 12:42 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] You mean: mailx -m -s Test Message [EMAIL PROTECTED] EOF `ux2dos /home/report/tbsp.lst | uuencode /home/report/tbsp.lst` This is from an HP-UX system hth mohammed --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: All, I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun Unix box to myself when the batch job runs. Anybody been able to do this? I can send the text of the file, but what I really want to do is to send the file (it's an Excel Spreadsheet). thanks in advance. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Send Mail in Unix
Here what I do on our SUN (cat $ORACLE_BASE/THO1/scripts/backup_misc.log ; uuencode $ORACLE_BASE/THO1/scripts/crontab_content.txt crontab_content.txt ; uuencode $ORACLE_BASE/THO1/scripts/pfile_content.txt pfile_content.txt)| $MAIL -s Backup misc files THO1 $EMAIL_ADDRESS Hope it helps Daniel -Original Message- Mercadante, Thomas F Sent: Thursday, February 13, 2003 12:45 PM To: Multiple recipients of list ORACLE-L Mohammed, thanks, but the -m option does not seem to exist in Sun Unix. $ mailx -m mailx: illegal option -- m Usage: mailx -eiIUdFntBNHvV~ -T FILE -u USER -h hops -r address -s SUBJECT -f FILE users any other ideas? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, February 13, 2003 12:42 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] You mean: mailx -m -s Test Message [EMAIL PROTECTED] EOF `ux2dos /home/report/tbsp.lst | uuencode /home/report/tbsp.lst` This is from an HP-UX system hth mohammed --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: All, I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun Unix box to myself when the batch job runs. Anybody been able to do this? I can send the text of the file, but what I really want to do is to send the file (it's an Excel Spreadsheet). thanks in advance. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Garant INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Send Mail in Unix
I usually ... uuencode filename filename | mailx -s foo [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 13, 2003 11:39 AM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
