Hi

Thanks for testing it out. Did you dropped the datafile or the tablespace from the database or just phyically from the server? I hope that we did not have any miscommunication!

I know that I can recover tablespace or datafiles dropped phyically from the server in RMAN. However, I am trying to recover the tablespace from the command "drop tablespace test" which the answer I got is not possible unless i clone the db or import the tablespace.

I think the answers they gave are true, but i am actually looking for a solution within RMAN recovery, which i was told by the metalink guys that it is not possible for dropped tablespace.

I did read up about TSPITR, but as my database is running on standard edition, therefore this feature is not supported :(

Maybe you can share with me how did u create and drop the tablespace please? Have a nice trip Hrishy and hope to hear from you soon! Cheers!