To learn time based recovery to recover a dropped table practically,i did the following.

SQL> create table emp(id number)

Table created.

SQL> insert into emp values(1);

1 row created.

SQL> commit;

Commit complete.

I dropped the table at March 15,2006-2:25P.M.

SQL> drop table emp;

Table dropped.

To do time based recovery,I shutdown the database..

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.

Then,i mount the database..

SQL> startup mount

Then,i issued the following command,to do time based recovery & to recover the table..

SQL> RECOVER DATABASE UNTIL TIME '2006-04-15:02:20:00';
Media recovery complete.

Since i recovered the database to the time 2:20P.M,the dropped table EMP should be there now,but when i tried to look at the table,it shows the table doen't exist,

SQL> SELECT * FROM EMP;
SELECT * FROM EMP
*
ERROR at line 1:
ORA-00942: table or view does not exist

My questions are,

1)Why the table "EMP" is not recovered?

2)Did i do anything wrong while doing the time based recovery?

3) If the procedure i followed to do time based recovery is wrong,can anyone explain me,how to do this & recover a dropped table?

Thanks,
Malru