Oracle-L: RE: Help with Unix find command

From: Darrell Landrum <dlandrum_at_zalecorp.com>
Date: Thu, 10 Apr 2003 10:44:12 -0800
Message-ID: <F001.0057F0E3.20030410104412@fatcity.com>

This needs a "-" in front of exec

find . blah -mtime +1 -exec ls {} \;

>>> rlsmith_at_kmg.com 04/10/03 11:43AM >>> oracle_at_typeOMENU:> export ORACLE_SID=openview oracle_at_openview:> find . -name ""${ORACLE_SID}_exp_full*.log"" -mtime +1
exec ls {} \;
find: missing conjunction
oracle_at_openview:> find . -name "${ORACLE_SID}_exp_full*.log" -mtime +1 exec
ls {} \;
find: missing conjunction
oracle_at_openview:> find . -name '${ORACLE_SID}_exp_full*.log' -mtime +1 exec
ls {} \;
find: missing conjunction
oracle_at_openview:>

-----Original Message-----
Sent: Thursday, April 10, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L

In Unix shells, variables and wildcards get parsed BEFORE they get passed to
the program. This is fine most of the time, like when you "ls mydir/*", but
not for find.

Try enclosing the ${ORACLE_SID}_exp_full*.log in quotes (double or single).

HTH! GL! :) Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_qtiworld.com           Quad/Tech International, Sussex, WI

USA p.s. I hope I was the intended recipient of this e-mail. If not, ignore my
error!

-----Original Message-----
Sent: Thursday, April 10, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L

I am trying to format a find command to delete files older than n days. The
command is in a script and incorporates the ORACLE_SID variable. I can't get the command to work with the first part of the file name as a
variable. It works fine if I hard code it. Any ideas?

Example: find . -name ${ORACLE_SID}_exp_full*.log -mtime +1 -exec ls {} \;

Thanks!
Ron
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.com

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: ListGuru_at_fatcity.com (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). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know
immediately by return e-mail if you have received this message by mistake,
then delete the e-mail message. Thank you.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Smith, Ron L.
INET: rlsmith_at_kmg.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Darrell Landrum
INET: dlandrum_at_zalecorp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------