Problem :
The problem is that the trace files from a database should be cleaned up when the trace file creation time was older that 30 days

Solution :
Creating a windows batch script that uses the delete function "del /q" to delete the files but only those files that are older than a given date. This script is driven by a parameter file every line in the file gives information about the  <directory> +<filemask> + <keep Time> for the directory that should be cleaned up.

Download Script - example par file

---

Problem :
Windows. does not know the UNIX oraenv script.
Solution :
Created an advanced and simple oraenv script for windows without the usage of an oratab file.

Download oraenv
Download oraenv_simple

---

Problem :
retrieve multiple directory via ftp script.
Solution :
A script ftp_rerieve.cmd uses a parameter file to retrieve files from a ftp server.

the parmater file (ftp_retrieve.par)should be build up as folows :
RET_DIR;(Desitination directory);(Soure directory);(File mask ex : *.*);(BIN or ASC);

Download ftp_retriev.cmd

---

Problem :
Date functionalities in scripts

Solution:
download : getdate.cmd