FLASHBACK DATABASE AND QUERIES

FLASHBACK FEATURES   Purging the Recycle Bin   purge table sales.woodscrews; purge index sales.woodscrews_pk_idx; purge tablespace sales; purge recyclebin;   Undropping Objects in the Recycle Bin   flashback table ws_app.woodscrews to before drop; select object_name, original_name, droptime, dropscn from user_recyclebin; flashback table bonus to before drop rename to bonus_deb;   ———–Accidentaly Delete——————————————   Accidentally dropped table MHC_PA_INT_PPA_SPN_RL_TBL from MHCPA schema […]