Good start but the problem is that the datafile is now called "/oracle/sid/dbs/MISSING00067" as far as the datadictionary is concerned. Try to a "rename datafile" command so that the dictionary thinks its called the same thing and then try bringing it onlimne - you will still need to do a recovery so will need the archived redo logs. Should be able to do a "recover tablespace PSAPBTABD " and then "alter tablespace PSAPBTABD online"

-B