-
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)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|