How to rename Duplicate datafile names in Oracle??
11g database - Datafile created with extra blank space similar to existing datafile. Please note…
Read moreFebruary 2023
How To Modify AWR Snapshot Setting ??
We can change the snap_interval and retention period for the automatic awr snapshot collection, using…
Read moreORA-12101: Materialized View Issue
During 19c Upgrade, Materialized view creation which is from a pre-built base table is showing…
Read moreORA-39358: Export Dump File Version 12.1.0.2.0 Not Compatible With Target Version 11.2.0.4.0
After upgrading a database from 11.2.0.4 to 12.1.0.2, the following errors are reported executing a…
Read moreRAID (Redundant Array of Inexpensive disks)
RAID stands for Redundant Array of Inexpensive Disks which was later interpreted to Redundant Array…
Read moreWhat is Checkpoint ?
A checkpoint is an operation that Oracle performs to ensure data file consistency. When a…
Read moreGrid Infrastructure Files and Management Database in RAC
Oracle 19c Grid Infrastructure requires certain files and provides tools to access each Standalone Cluster…
Read more