Hi Mooks

I for the curiosity tested this and was able to sucessfully restore the dropped tablespace .Using the steps that i mentioned above. I am not sure why metalink guys told you recovering a dropped tablespace is not possible.

My rman script was

Code:
RMAN> run {
2> set until time "to_date('08-07-2005 18:58:00','dd-mm-yyyy hh24:mi:ss')";
3> restore database;
4> recover database;
5> sql "ALTER DATABASE OPEN RESETLOGS";
6> }
The to_date was used so rman can restore the old controlfile.

and here is the output after the database was open

Code:
SQL> select * from v$tablespace;

       TS# NAME                           INC
---------- ------------------------------ ---
         0 SYSTEM                         YES
         1 UNDOTBS                        YES
         2 TOOLS                          YES
         4 TEMP1                          YES
         5 USERS                          YES
There is another of dropped tablespace recovery its called TSPITR.Look up for that in the docs.

I am not sure why metalink guys told you this is not possible.

I would be travelling and may not have acesses to oracle for sometime in case you dont get updates to this thread.

regards
Hrishy