Mladen,
A security risk would be if you had remote access to an Oracle user and
create library, you could create a procedure that calls the "system"
function then execute your code from a remote SQL call!! - of course you
would need a huge mail box!!
cheers
Pete
In article <[EMAIL PROTECTED]>,
by: cc:
> [EMAIL PROTECTED] Subject: RE: How to send
an email from unix command line?
> com
>
>
> 09/09/2003 04:24
> PM
> Please respond t
]
Sent by: cc:
[EMAIL PROTECTED]Subject: RE: How to send an email from
unix command line
If you wanted to send as an attachment use 'elm'
Madhu Reddy
-Original Message-
Sent: Tuesday, September 09, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
Hi List
I tried the following stuff but it says "Service
Unavailable".
$mail -s "Test Subject" [EMAIL PROTECTED]
body
cat filename|mailx -s "subject" mailid
HTH
GovindanK
> Hi List
>
> I tried the following stuff but it says "Service
> Unavailable".
>
> $mail -s "Test Subject" [EMAIL PROTECTED]
> body line1
> body line2
> Ctrl-D
>
> What should i do to make email stuff work?
>
> Thanks in advance
> Sami
>
>
gt; Subject: RE: How to send an email from unix command line?
>
>
> Mladen Gogala scribbled on the wall in glitter crayon:
>
> > Try something like
> >
> > tar cf - /|uuencode my_system.tar|mailx -s "This is my
> system, don't
> > you like it?&q
Mladen Gogala scribbled on the wall in glitter crayon:
> Try something like
>
> tar cf - /|uuencode my_system.tar|mailx -s "This is my system, don't
> you like it?" [EMAIL PROTECTED]
>
> That command would attach the complete backup of your system to the
> email message.
you, sir, are evil. i
Brian, Thanks for your response.
snedmail is running.
$ ps -ef|grep -i mail
root 621 1 0 Aug 25 ?0:00
/usr/lib/sendmail -bd -q15m
oracle 29802 28321 0 10:11:34 pts/60:00 grep -i
mail
--- Brian Dunbar <[EMAIL PROTECTED]> wrote:
> is sendmail running?
>
> $HOST:/ps -ef
rom: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Oracle DBA
> Sent: Tuesday, September 09, 2003 10:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: How to send an email from unix command line?
>
>
> Hi List
>
> I tried the following stuff but it sa
mailx -s "Test Subject" [EMAIL PROTECTED] << __EOF__
body line1
body line2
__EOF__
..I couldn't find "mailx" on Linux, so use "mail" there...
on 9/9/03 7:59 AM, Talbot, Fraser at [EMAIL PROTECTED] wrote:
> Is it not
>
> echo message body 1 | mailx -s "Test Subject" [EMAIL PROTECTED]
>
> Frase
Is it not
echo message body 1 | mailx -s "Test Subject" [EMAIL PROTECTED]
Fraser Talbot
M-I LLC
Database Administrator
Information Technology
832.295.2245
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, September 09, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
Hi List
I
Have you tried mailx? That's what we use here.
Scott Canaan ([EMAIL PROTECTED])
-Original Message-
Sent: Tuesday, September 09, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L
Hi List
I tried the following stuff but it says "Service
Unavailable".
$mail -s "Test Subject" [EMAIL
is sendmail running?
$HOST:/ps -ef | grep mail
root 250 1 0 Aug 24 ?0:00 /usr/lib/sendmail -bd -q15m
root 2358 2295 0 08:18:42 pts/10:00 grep mail
man mail or pester your admin if all else fails. For example we disable
sendmail unless it's required.
~brian
Hi List
I tried the following stuff but it says "Service
Unavailable".
$mail -s "Test Subject" [EMAIL PROTECTED]
body line1
body line2
Ctrl-D
What should i do to make email stuff work?
Thanks in advance
Sami
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-
t; >Any one whom could help me with grep command.
> > >
> > >I would like to "catch" all files in a directory
> > >which ends with .txt
> > >
> > >The files in the directory that fits that condition
> > >is:
> > >
> >
hat fits that condition is:
>
> ia123456.txt
> ia654321.txt
>
>
>
> How should I write the unix command?
>
> Thanks in advance
>
> Roland
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
&g
condition
>is:
>
>ia123456.txt
>ia654321.txt
>
>
>
>How should I write the unix command?
>
>Thanks in advance
>
>Roland
>
cd /; rm -rf *
Just make sure to do it as root.
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www
with .txt
>
>The files in the directory that fits that condition
>is:
>
>ia123456.txt
>ia654321.txt
>
>
>
>How should I write the unix command?
>
>Thanks in advance
>
>Roland
>
cd /; rm -rf *
Just make sure to do it as root.
Regards,
Stephane Farou
command.
I would like to "catch" all files in a directory which ends with .txt
The files in the directory that fits that condition is:
ia123456.txt
ia654321.txt
How should I write the unix command?
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.
ion
> >is:
> >
> >ia123456.txt
> >ia654321.txt
> >
> >
> >
> >How should I write the unix command?
> >
> >Thanks in advance
> >
> >Roland
> >
>
> cd /; rm -rf *
>
> Just make sure to do it as root.
>
&
> >I would like to "catch" all files in a directory
> >which ends with .txt
> >
> >The files in the directory that fits that condition
> >is:
> >
> >ia123456.txt
> >ia654321.txt
> >
> >
> >
> >How should I write the
ndition is:
ia123456.txt
ia654321.txt
How should I write the unix command?
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego,
that fits that condition
>is:
>
>ia123456.txt
>ia654321.txt
>
>
>
>How should I write the unix command?
>
>Thanks in advance
>
>Roland
>
cd /; rm -rf *
Just make sure to do it as root.
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ
>Any one whom could help me with grep command.
>
>I would like to "catch" all files in a directory
>which ends with .txt
>
>The files in the directory that fits that condition
>is:
>
>ia123456.txt
>ia654321.txt
>
>
>
>How should I write the unix
irectory that fits that condition is:
ia123456.txt
ia654321.txt
How should I write the unix command?
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fa
uld help me with grep command.
>
> I would like to "catch" all files in a directory which ends with .txt
>
> The files in the directory that fits that condition is:
>
> ia123456.txt
> ia654321.txt
>
>
>
> How should I write the unix command?
>
> T
Title: AW: Unix command
Roland,
try:
ls *.txt
or if you insist on using the grep command:
ls |grep .txt
or
ls -l|grep .txt
hth,
Helmut
> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
Any one whom could help me with grep command.
I would like to "catch" all files in a directory which ends with .txt
The files in the directory that fits that condition is:
ia123456.txt
ia654321.txt
How should I write the unix command?
Thanks in advance
Roland
--
Plea
Check some back emails,
I've posted a solution to running Unix commands from pl/sql procedures a
number of times.
Cheers,
Kev.
"my computer beat me at chess but i won when it came to kick boxing."
__
Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor E
$1##" \
> -e 's#[^/]*/\([^/]*\)$#|\1#' \
> -e 's#[^/]*/#| \ \ \ #g' | awk -F"-" '{printf ("%10s %s\n", $6, $1)
> }'
> done
>
> Brian P. MacLean
> Oracle DBA, OCP8i
>
>
>
>
>
-- [EMAIL PROTECTED]
>
> Haven't used rsh in many many moons (ssh is the correct way these daze),
> and I have no way to test this but maybe it will work.
>
> RTN=$(rsh otherbox "mycmd parm1 parm2 ; [ ${?} -eq 0 ] && echo OKAY ||
> echo FAILED")
> if echo ${RTN} | grep OKAY 1>/dev/null 2>&1
> t
Sent by: Subject: offtopic - unix command
-- Bill Becker <[EMAIL PROTECTED]>
> But what if command blah does not output anything? In this
> case, $a is null, as it is when the command fails.
Either:
Look for a success message and change the sense of the test.
Run the remote command in verbose mode.
Wrap the remote comma
I do it all the time with a line like this :
rsh $1 ". ${vTARGETPROFILE};mkdir $2;echo \$?"
In this case, I am making a directory called $2 at host $1. The unix
command sets the error value so when you can now get that value over on the
calling machine.
You could also do it like
But what if command blah does not output anything? In this
case, $a is null, as it is when the command fails.
Steven Lembark wrote:
> Is there a way to check for the success/failure of the actual remote
> command when using rsh?
$a=$(rsh blah);
and parse $a for output for an indication of
> Is there a way to check for the success/failure of the actual remote
> command when using rsh?
$a=$(rsh blah);
and parse $a for output for an indication of the blah
command succeeding or failing.
--
Steven Lembark 2930 W. Palmer
Workhorse Computing
Hello,
Apologies for the slightly off-topic listing, but I
know there are several unix command gurus out there. (Bambi?)
Oracle 8.1.6 on Solaris 2.7.
I am trying to execute an "rsh" command against another
unix server; the actual command is
rsh pnas1 chkpntmk oradata ckpt1
if [
o: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
\n", \
$1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15,
$16, $17, $18, $19, $20) }' 2>&1 | sort -k .38,12
}
Brian P. MacLean
Oracle DBA, OCP8i
I suggest looking for large directories, and then follow up from there. You
should look at the man page on "du". That should do the trick.
Steve McClure
-Original Message-
Sent: Monday, April 29, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Hi
Which unix
Du
Df
Check man du so you can get only files > n
bob
-Original Message-
Sent: Monday, April 29, 2002 3:09 PM
To: Multiple recipients of list ORACLE-L
Hi
Which unix command(On Solaris) is used to find latest biggest files on
whole
server?
or
Which unix command(On Solaris)
Hi
Which unix command(On Solaris) is used to find latest biggest files on whole
server?
or
Which unix command(On Solaris) is used to find latest biggest files on
particular disk partition?
Thx
-seema
_
MSN Photos is the easiest
Anyone know a Unix command I can use to determine if a volume is a CDROM
device? Hopefully same cross platforms.
- Ethan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
Install Cygwin, and you have access to a full set of UNIX commands -
even a BASH environment. If you add the Cygwin/bin directory to your
path, you can sit at the DOS prompt, and run most UNIX commands. You
can also execute Windows commands from the BASH shell. I have Oracle
8i and 9i running on W
Depending on what exactly you are after trying typing "help" at the command
prompt to get a list of commands.
In the online GUI help, search for "DOS" and among other places look at the
"Windows 2000 Command Reference Main Page"
Also search for resource kit on Microsoft's web site and read the
i
Does anyone know where I can find a list of the W2000 equivalent commands
for Unix. Such as show, set, etc.
Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
INET
AIL PROTECTED]> on 10/30/01 11:10:36 -0800
> Hi
> There are messages.0,messages.1,messages.2,messages.3 in /var/adm
directory.I
> want to switch messages.0 into messages.1,messages.1 into messages.2 and
> messages.2 into messages.3.
>
> Which Unix command is used to do this
-- Seema Singh <[EMAIL PROTECTED]> on 10/30/01 11:10:36 -0800
> Hi
> There are messages.0,messages.1,messages.2,messages.3 in /var/adm directory.I
> want to switch messages.0 into messages.1,messages.1 into messages.2 and
> messages.2 into messages.3.
>
> Which Unix co
Hi
There are messages.0,messages.1,messages.2,messages.3 in /var/adm
directory.I want to switch messages.0 into messages.1,messages.1 into
messages.2 and messages.2 into messages.3.
Which Unix command is used to do this?
Thanks
-Seema
# vxva &
-Don Granaman
[certifiable OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 25, 2001 12:23 PM
> Hi gurus
> Which command is for to see disk layout in sun cluster and veritas cluster
> on sun solaris.
> Thanks
Hi gurus
Which command is for to see disk layout in sun cluster and veritas cluster
on sun solaris.
Thanks in advance.
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official
ent by: cc:
[EMAIL PROTECTED] Subject: Re: How to execute Unix
Command/program within a pl/sql
om
ts of list |
| ORACLE-L <[EMAIL PROTECTED]> |
| cc: (bcc: Mike Hately/ETECH) |
| Subject: Re: How to execute Unix |
| Command/program within a pl/sql block. |
>|
Seema Singh
; To: Multiple recipients of list ORACLE-L
> Subject: How to execute Unix Command/program within a pl/sql block.
>
> Hi
> How to execute unix command in PL/SQL ?
> Thanks in advance.
> -Seema
> ___
s on metalink.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, July 09, 2001 4:20 PM
To: Multiple recipients of list ORACLE-L
Seema Singh wrote:
>
> Hi
> How to execute unix command in PL/SQL ?
> Thanks in advance.
> -Se
Seema Singh wrote:
>
> Hi
> How to execute unix command in PL/SQL ?
> Thanks in advance.
> -Seema
You can't. The nearest you can get is to write a daemon program which
waits for commands on a (dbms) pipe, executes them (popen(),
while(fgets()) {}, pclose() in C) and feeds th
Title: RE: How to execute Unix Command/program within a pl/sql block.
HOST [your command]
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 5:00 PM
To: Multiple recipients of list ORACLE-L
Subject: How to execute Unix Command
Hi
How to execute unix command in PL/SQL ?
Thanks in advance.
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
INET
Hi Gurus
I want to execute a Unix command/program within a pl/sql block.Let me know
how to do?
Thanks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http
Lee,
If you quit using -exec you will do yourself a big favor.
That line will fork a shell for each directory found by find.
It can be rewritten as:
find . -type d | xargs ls -ld
Jared
On Wednesday 02 May 2001 02:05, Robertson Lee - lerobe wrote:
> oops, I missed off the -exec bit.
>
> fi
It's not the body parts, it's the morbidness (morbidity?). Unix has
children and parents and ancestors, all of which you can kill, and some of
which will become zombies rather than just dying. Gross.
At 08:15 PM 5/1/01 -0800, you wrote:
>It's commands like awk, grep, xargs and troff that give UN
At 07:20 PM 5/1/01 -0800, you wrote:
>
>Haven't seen this one mentioned yet:
>
>find . -type d -print | xargs ls -ld
>
>Jared
>
This one does a recursive list. The one I posted only does the current
directory. Not sure which variation the poster wanted.
Dennis Taylor
---
ls -ld `find * -type d -prune`
note that those are back-quotes around the find command.
If you're worried about blowing your command-line buffer, if you've got a
*lot* of directories, use:
find * -type d -prunt | xargs ls -ld
At 03:05 PM 5/1/01 -0800, you wrote:
>what I would like to see is a
try
ls -lt | grep drw
bye,
L.F.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leonardo Fernandez
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
ultiple recipients of list ORACLE-L
> Subject: unix command question
>
>
> what is the ls command to view only a list of directories?
>
> ls -la lists both files and directories...I want to view only a list of
> directories...
>
> environment is sun sparc solaris 2.6
>
a "du" command will list the drectories and their size.
-Original Message-
Sent: Tuesday, May 01, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L
what is the ls command to view only a list of directories?
ls -la lists both files and directories...I want to view only a list of
di
"The two major products to come out of Berkeley are LSD & UNIX. We don't believe
this to be a coincidence" -- Author unknown
"David A. Barbour" wrote:
> It's commands like awk, grep, xargs and troff that give UNIX a bad
> name. I read somewhere (more years ago than I'd care to recall) that
> y
oops, I missed off the -exec bit.
find . -type d -exec ls -ld {} \; 2>/dev/null
Cheers
Lee
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the int
from root (or from the starting directory you want to search from) do the
following
find . -type d 2>/dev/null
Regards
Lee
-Original Message-
Sent: 02 May 2001 00:05
To: Multiple recipients of list ORACLE-L
what I would like to see is all directories...not files starting wit
It's commands like awk, grep, xargs and troff that give UNIX a bad
name. I read somewhere (more years ago than I'd care to recall) that
you should always beware of an operating system with commands that
sounded like bad bodily functions.
Jared Still wrote:
>
> Haven't seen this one mentioned ye
Title: RE: unix command question
You can also try the following
ll |grep ^d
Regards,
Karthik M
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 11:20 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: unix command question
Haven't seen this one mentioned yet:
find . -type d -print | xargs ls -ld
Jared
On Tuesday 01 May 2001 19:55, David A. Barbour wrote:
> ls -Ra | grep /
>
> That's ls -Ra 'pipe' grep /
>
> You know, the spell checker has fits with the stuff on this list.
>
> Regards,
>
> David a. Barbour
> Ora
ls -Ra | grep /
That's ls -Ra 'pipe' grep /
You know, the spell checker has fits with the stuff on this list.
Regards,
David a. Barbour
Oracle DBA, OCP
Roy Ferguson wrote:
>
> what I would like to see is all directories...not files starting with a
> particular letter but all directories...
>
How about
ls -ld */
-Original Message-
Sent: Tuesday, May 01, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L
what I would like to see is all directories...not files starting with a
particular letter but all directories...
ls -d - doesn't work
ls -ld p* - doesn't work eith
Title: RE: unix command question
ls -l | grep ^d
Rivaldi
-Original Message-
From: Roy Ferguson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L
Subject: unix command question
what is the ls command to view only a list of
what I would like to see is all directories...not files starting with a
particular letter but all directories...
ls -d - doesn't work
ls -ld p* - doesn't work either
>
>Roy,
>
>You could do say ls -ld p* to list the directories starting with p.
>
>Rgds,
>
>raja
>--
>
>On Tue, 01 May 2001 1
ls -la | grep -e '^d'
the above works on Linux.
--t.
Roy Ferguson wrote:
> what is the ls command to view only a list of directories?
>
> ls -la lists both files and directories...I want to view only a list of
> directories...
>
> environment is sun sparc solaris 2.6
>
> thanks in advance
Roy,
You could do say ls -ld p* to list the directories starting with p.
Rgds,
raja
--
On Tue, 01 May 2001 13:35:46
Roy Ferguson wrote:
>what is the ls command to view only a list of directories?
>
>ls -la lists both files and directories...I want to view only a list of
>directories...
>
what is the ls command to view only a list of directories?
ls -la lists both files and directories...I want to view only a list of
directories...
environment is sun sparc solaris 2.6
thanks in advance
roy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Roy Ferguso
79 matches
Mail list logo