A user dropped number of tables (~1449) on Development server and the user has no record of the tables name that were dropped.
Things we know:
1. Date on which the action was performed.
2. Username of the user who executed the statements.
Is it possible to get the table names (that were dropped)?
Best Answer
If you have the recyclebin turned on in your database you can query the DBA_RECYCLEBIN view to find which objects were dropped within a certain time period.
You can issue a FLASHBACK command to restore the table;
Alternatives are to flashback to a specific SCN, TIMESTAMP, etc.
See https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9012.htm#SQLRF01802 and http://docs.oracle.com/cd/B28359_01/server.111/b28310/tables011.htm#ADMIN01511 for some more reading (it never hurts to read)