• Ahhh.....the Beauty of Oracle!

    Restoring a table can of course be done by extracting the table from a dump but easier is to ENABLE_ROW_MOVEMENT on the table in question.

    You can then FLASHBACK TABLE until time or SCN (if you need it). If someone performs a DROP TABLE it is possible to recover it from the $RECYCLEBIN as long as the clever Person doesn't DROP with PURGE!

    It obviously wasn't the only reason we chose it but it was certainly a key factor.