Hi
I tried to do this on a test machine(win2k) to see how rocovery process works for a Point in time, it seems that it is not working - i am going wrong somewhere,

this is how i did
SVRMGR> alter tablespace users begin backup;

copy datafile users01.dbf as users01.bak

SVRMGR> alter tablespace users end backup;

create a table T1 insert some records;
commit it
create a table T2 insert soem records;
commit it;

Time: 16:39:00
at Time 16:40:00 I drop table T2.
assuming now i want the table back
I do the below.


SVRMGR> shutdown immediate

rename datafile users01.bak to users01.dbf

SVRMGR> startup mount

SVRMGR> alter database datafile 'D:\oracle\oradata\orcl\USERS01.DBF' online;
Statement processed.

SVRMGR> recover datafile 'D:\oracle\oradata\orcl\USERS01.DBF';
Media recovery complete.
SVRMGR> recover database until time '2001-05-01:16:39:00';
Media recovery complete.
SVRMGR> alter database open resetlogs;


after this i log on and find the table T1 is there with data but couldnt find table T2.

What is the problem in this procedure.
Thanks for any help
-dharma