This article looks what Oracle does when you perform a tablespace point-in-time recovery (TSPITR) - and also what it doesn't do, depending on the version being used.

This story continues at http://www.dbasupport.com/oracle/ora...Drills02.shtml