Hello All,

Our database consists of four datafiles for tablespace "temp" (temp1.dbf,
temp2.dbf, temp3.dbf, temp4.dbf). Temp4.dbf file consists on another
filesystem and someone has accidently deleted this file. There are no
backups of this datafile. The data in these tables are important. Is there
any way to recreate temp4.dbf? The "temp" tablespace is permanent. Any help
is greatly appreciated.

Thanks,
Brandon
Oracle LazyDBA home page