Thanks Eric. let me confirm : nothing can be done on PROD as such. and the only possible way is as i mentioned in my first mail . isn't it ? Regards, Prem. On 5/25/05, Eric Buddelmeijer <Eric.Buddelmeijer@xxxxxxxxxx> wrote: > Been there, done that. :-( > You can use transportable tablespaces as long as you restore the second > server to the same OS in 9i. (rman probably won't work with another os fo= r > this purpose as well). And you only have to restore the deleted tablespac= es, > system ts and undo ts. TTS is a lot faster than export/import most of the > time. -- //www.freelists.org/webpage/oracle-l