Oracle-L: RE: Help with Unix find command

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Thu, 10 Apr 2003 10:53:55 -0800
Message-ID: <F001.0057F0FE.20030410105355@fatcity.com>

Got it! Thanks!
Ron

-----Original Message-----
Sent: Thursday, April 10, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L

Hey Ron,

Is the variable ORACLE_SID set inside the script? I'd add that, if not. Also, what works for me when using an asterisk in a find command is to double quote the target name...

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

This command works on HP, let me know if this doesn't fix it.

>>> rlsmith_at_kmg.com 04/10/03 09:58AM >>> 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
---------------------------------------------------------------------

--

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

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