Category Archives: Oracle 19c

Accidental bulk updates are a common problem in production databases. In this example, we’ll explore … Read More →

Accidental table drops are one of the most common mistakes in production databases. Fortunately, Oracle … Read More →

In Oracle Database 19c, when you don’t just want the old value at one moment—but … Read More →

In mission-critical systems running on Oracle Database 19c, accidental updates are common — especially salary … Read More →

When you change UNDO_RETENTION in Oracle Database 19c, you must ensure that your UNDO tablespace … Read More →

Managing UNDO correctly in Oracle Database 19c is critical for transaction consistency, read consistency, flashback … Read More →

In Oracle Database 19c, REFRESH FAST ON COMMIT allows a Materialized View (MV) to be … Read More →

In Oracle Database 19c, a Materialized View Log (MV Log) is a database object that … Read More →

In Oracle Database 19c, when a user account (for example SYSTEM) becomes EXPIRED, the password … Read More →