Oracle-L: RE: Help with Unix find command

From: Nelson, Allan <anelson_at_midf.com>
Date: Thu, 10 Apr 2003 08:58:52 -0800
Message-ID: <F001.0057EE0D.20030410085852@fatcity.com>

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

You very nearly got it! You have to quote the -name spec because if you don't the shell will glob the * character for you.

Allan

-----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
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
---------------------------------------------------------------------

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).

This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]

--

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

Author: Nelson, Allan
INET: anelson_at_midf.com

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