Time based Recovery to recover a dropped table
To learn time based recovery to recover a dropped table practically,i did the following.
SQL> create table emp(id number)
SQL> insert into emp values(1);
1 row created.
I dropped the table at March 15,2006-2:25P.M.
SQL> drop table emp;
To do time based recovery,I shutdown the database..
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?
Click Here to Expand Forum to Full Width