Loss of Undo tablespace
640772Nov 1 2008 — edited Nov 3 2008Hello Friends
I am confuse about a snario, please clear it:
What if we loss undo tablespace(data files), and all files remain safe(database in archive log 9i) and the tablespace have some active transactions at the time of failure. My question is that how oracle will recover ? and where the undo data for uncommited transaction will come from at the time of recovery.
Sunil Kumar