have 2 oracle tables, one identifying an ID and a second table that identifies where files owned by the ID reside on the disk. (ID's may have data but not be residents of this system) The second table has an entry which indicates the last time the file was opened. I want to identify which files have not been opened in the last 60 days, move them to a new location to slower storage disks then update oracle on the new location so the Application that uses this info will be able to locate the new location.
I was supplied a perl script written by someone who is no longer here and was in a hurry to finish it before he left. The parts/queries work individually but the logic that merges the two and does the date logic stops at the <STDIN>. I have an email to the author asking that question. He is the decent sort that will answer.
thanx,
bill