If you accidentally dropped a table, can you recover it back?
The answer is yes, if you have the recycle bin feature turned on.
You can use the FLASHBACK TABLE ... TO BEFORE DROP statement
to recover a dropped table from the recycle bin as shown in the
following SQL script: