How to find when a table was last modified
For each row in a table, ORA_ROWSCN returns the SCN information of the last change made to that row. This...
March 13, 2026
2026
Enabling debugging in RMAN
Debugging/monitoring can be performed to obtain more detailed information about RMAN processes. This allows us to gain more insight than...
March 13, 2026
ORA-12988: cannot drop column from table owned by SYS
When attempting to delete a column from a table owned by a SYS user, the error “ORA-12988: cannot drop column...
March 13, 2026
Read Only Table Partitions
Read-Only Partitions Starting with Oracle version 12.2, partitions or sub-partitions of a table can be marked as read-only. This can...
March 13, 2026
Assertions Use Cases in Oracle
Assertions are boolean expressions that have the semantics of a constraint. The database must ensure the truth of these boolean...
March 12, 2026
Free Gateway to Oracle Database (Free SQL)
For developers, students, and database enthusiasts, getting hands-on practice with a powerful database system like Oracle has often required...
March 5, 2026
PDB Lockdown Profiles
PDB Lockdown Profiles are a security feature in Oracle’s multitenant architecture that allows administrators to restrict specific operations and features...
March 5, 2026
Oracle Flex Clusters
Oracle Flex Clusters From Oracle Grid Infrastructure 12c Release 2 (12.2) onward, all cluster configurations are implemented as Oracle Flex...
March 3, 2026
Transparent Application Continuity (TAC)
What is Transparent Application Continuity (TAC)? With the release of Oracle Database 18c, Transparent Application Continuity introduces an automated method...
February 27, 2026
Recovery steps for OCR (Oracle Cluster Registry), voting disks, or ASM passwords in an Oracle RAC 19c
Losing OCR (Oracle Cluster Registry), voting disks, or ASM passwords in an Oracle RAC 19c environment is critical but recoverable....
February 7, 2026
2025
Oracle Globally Distributed Database
Oracle Globally Distributed Database Introduction Oracle’s 26ai release introduces a groundbreaking innovation: the Globally Distributed Database, a fully managed, horizontally scalable...
December 30, 2025
How to find chained rows in a table ?
A chained row is a row that does not fit into a single database block. For example, if you try...
December 23, 2025
DIA-49803: Purge not possible due to incompatible schema version
This error indicates that there’s a schema version mismatch between the ADRCI (Automatic Diagnostic Repository Command Interpreter) utility and the...
November 27, 2025
Oracle Database 23ai key innovations with examples
Oracle Database 23ai is the latest long-term support release, and its name explicitly highlights its core focus: Artificial Intelligence. The “ai”...
October 31, 2025
How to move the Oracle ASM instance password file from the file system to the disk group ?
When the password file is stored inside a disk group, it is automatically replicated across all disks in the group,...
October 16, 2025
