Hi Eric ,=20 since the tablespaces are dropped , the information about it will be =20 removed from the control file also . so , TSPITR is also ruled out on PROD as such . Please correct me if i'm wrong. Thanks & Regards, Prem. On 5/25/05, Eric Buddelmeijer <Eric.Buddelmeijer@xxxxxxxxxx> wrote: > You can also try a tablespace point in time recovery. I personally would = not > do that until I had some scripts that would do that for me before I would= do > it in a production environment. Tested and all. From your question, I gat= her > you do not have those scripts. So if I where you, I would do it in a > separate environment. You can even test the TTS procedure there if you ha= ve > another database. Before trying that in a production environment. -- //www.freelists.org/webpage/oracle-l