If you know the tablespace name then the datafiles associated with that tablespace are in the DBA_DATAFILES view. The SQL is “seelct file_name from dba_datafiles where tablespace_name = upper(‘tablespace’);”.
Recovery is almost always the same thing. You have to restore the database from a past backup and then roll the entire thing forward to the point in time you are interested in. Actual datetime is meaningless to teh database it is always talking in terms of SCN’s and all of the SCN’s across all of the datafiles & control files MUST match. But since you specified that your using Oracle 9i or better, read up on LogMiner. You should be able to find the offending statement and the undo command to recover your missing data/program. If you can’t then the possibility of your doing a point in time recovery are dicy at best.