Re: Delete all files in user_dump_dest

On Tue, 25 Jul 2006 07:01:24 -0700, ericlaiys wrote:

> i'm running out of space on my current hard disk. can i delete all the
> user dump process which resides in the user_dump_dest ? Will i give the
> problem / error later on?
>
> Or what other alternative way of free hard disk space for Oracle
> running in Red Hat?

find $ORACLE_BASE/admin/$ORACLE_SID -name "*.trc" -mtime +7 -exec rm -f {} \;

-- 
http://www.mgogala.com