Prior to 12c, in case a table or
partition is dropped accidentally, there are certain ways to perform the table/partition recovery which includes Flashback database, database point in time recovery and
tablespace point in time recovery.
Starting 12c we can perform point-in-time recovery
for a single table
