If you drop a table or delete data mistakenly, then want rollback them, you can take the following methods:
1. Query the data before delete:
Select * from table_name as of timestamp date_before_delete.
Once you get the data before delete operation, how to recovery the data is needless to expatiate.
2. Flashback dropped table:
Flashback table table_name to before drop;