Hi,

Continuing with the tablespace recovery method, I did the following.

I took the tablespace(WHS) backup.
I dropped one table(order_detail)
I restored the tablespace as given by dragon:


RMAN> run {
sql 'alter tablespace whs offline immediate';
allocate channel ch1 type disk;
##set new name for datafile '/.../...' to '/.../...';
restore tablespace whs;
switch datafile all;
recover tablespace whs;
sql 'alter tablespace whs online';
}

## I don't know what this line means.

Now the tablespace is recovered, but I am unable to get the dropped table.
Where did I go wrong?
Badrinath