how to recover dropped table
i want o know how to recover a dropped table from archived logs.....
below are some of the steps i have performed but could n;t able to recover it...
sql>select * from test.tt;
sql>drop table test.tt;
then
rman target username/passowrd@string
rman>restore database;
sql>startup mount
sql>set autorecovery on
sql>recover database;
sql>recover database until time '2008-05-05:12:24:00';
but when i check the table it gives an error
'table or view doesn' exist...
pls help me.....
sql>