Oracle Database Discussions

Hi,

Somebody deleted records from 10,12 tables in one of the schema. I found in one of the forum that table can be restored also if it exists in the recyclbin. I checked by querying:

select object_name, original_name, type, can_undrop as "UND", can_purge as "PUR", droptime from recyclebin;

 > select type, can_undrop as "UND", can_purge as "PUR", droptime from recyclebin WHERE TYPE='TABLE' and droptime like '%2012-07-31%';
PHONE      TABLE			  YES YES 2012-07-31:10:23:08
TABLE			  YES YES 2012-07-31:10:23:08
TABLE			  YES YES 2012-07-31:10:23:08
TABLE			  YES YES 2012-07-31:10:23:08
TABLE			  YES YES 2012-07-31:10:23:08
- - 
- - 

I created a test table and dropped it and restored from recyclebin using following flashback table test query....but in my case tables are not dropped...these tables are shoing 0 records. How can I recover only records from recyclbin tables?
SQL> flashback table test to before drop;

Flashback complete.

DB=10.2.0.5 on RHL

Thanks a lot.

Best Regards