Flashback Database

How to Resolve ORA-38707: Media recovery is not enabled

by Ed Chen
September 29, 2021October 17, 2021

ORA-38707 Tried to enable flashback of whole database, but it failed with ORA-38706 and ORA-38707. SQL> alter database flashback on; alter database flashback on *… Read More »

Truncate vs Delete in Oracle

by Ed Chen
May 27, 2020December 10, 2022

Truncate vs Delete Here I compare the differences between TRUNCATE and DELETE an entire table in the following chart. Question Truncate Table Delete From DDL… Read More »